Unanswered

Custom entity only available in Power BI via OData feed, not TDS endpoint

(0) Share

Report

Posted on by kstiegler

I created two custom entities yesterday via the Solution customization portal and they were not available in Power BI using the current Dataverse connector. However, they were available in Power BI via the OData feed. Is there a setting I'm missing that needs to be toggled for these to show up using the Dataverse connector?

Categories:

Entities

Solution Explorer

Microsoft Dataverse

All responses (9)

Answers (0)

Bipin D365 971 on at

Like (1)

Report

Re: Custom entity only available in Power BI via OData feed, not TDS endpoint

HI @PowerBeeEye ,

Can you show me what connector you are using in Power Bi?

I have just created new custom entity in my instance and used below Dataverse connector. I could see the newly created custom entity.

Make sure you are creating your custom table in correct instance. And you are checking in same instance in Power Bi.

Try clicking refresh button as highlighted in my above image.

Regards,

Bipin Kumar
Follow my Blog: https://xrmdynamicscrm.wordpress.com/

Kudos and Accept my answer if helpful!
PowerBeeEye 7 on at

Like (0)

Report

Re: Custom entity only available in Power BI via OData feed, not TDS endpoint

Thanks for all the replies. The table is already searchable. Is there another setting I need to turn on?

searchable.png
Ram Prakash 5,166 Super User 2025 Season 1 on at

Like (1)

Report

Re: Custom entity only available in Power BI via OData feed, not TDS endpoint

Hello @kstiegler

Hope you are doing good.

Please make sure the field is SEARCHABLE.

Please mark as Answer if it is helpful and provide Kudos

Subscribe : https://www.youtube.com/channel/UCnGNN3hdlKBOr6PXotskNLA

Blog : https://microsoftcrmtechie.blogspot.com
kstiegler 14 on at

Like (0)

Report

Re: Custom entity only available in Power BI via OData feed, not TDS endpoint

In my case, it was a really simple solution - I just had to refresh the preview in Power Query. I haven't had the problem since then.
Prakash4691 1,332 on at

Like (1)

Report

Re: Custom entity only available in Power BI via OData feed, not TDS endpoint

Hi @kstiegler ,

As @bipinshan mentioned, enable change tracking in entity/table level will make table appears to the external systems.

If it answers your question. Kindly give kudo and accept as solution.

Regards,

Prakash
Bipin D365 971 on at

Like (0)

Report

Re: Custom entity only available in Power BI via OData feed, not TDS endpoint

Hi @PowerBeeEye ,

Have you tried enabling Change tracking checkbox on Entity page?

Thanks,

Bipin
PowerBeeEye 7 on at

Like (0)

Report

Re: Custom entity only available in Power BI via OData feed, not TDS endpoint

Did you ever figure this out? I have the exact same issue
kstiegler 14 on at

Like (0)

Report

Re: Custom entity only available in Power BI via OData feed, not TDS endpoint

@ChrisPiasecki Yep, published at the entity/table level as well as the "Publish all customizations" level, to no effect.
ChrisPiasecki 6,389 Most Valuable Professional on at

Like (0)

Report

Re: Custom entity only available in Power BI via OData feed, not TDS endpoint

Hi @kstiegler,

Did you publish customizations after creating your tables?

---
Please click Accept as Solution if my post answered your question. This will help others find solutions to similar questions. If you like my post and/or find it helpful, please consider giving it a Thumbs Up.