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:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (9)

Answers (0)

ChrisPiasecki 6,422 Most Valuable Professional on at

Like (0)

Report

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.

Was this reply helpful? Yes No
kstiegler 14 on at

Like (0)

Report

@ChrisPiasecki Yep, published at the entity/table level as well as the "Publish all customizations" level, to no effect.

Was this reply helpful? Yes No
PowerBeeEye 7 on at

Like (0)

Report

Did you ever figure this out? I have the exact same issue

Was this reply helpful? Yes No
Bipin D365 971 on at

Like (0)

Report

Hi @PowerBeeEye ,

Have you tried enabling Change tracking checkbox on Entity page?

Thanks,

Bipin

Was this reply helpful? Yes No
Prakash4691 1,332 on at

Like (1)

Report

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

Was this reply helpful? Yes No
kstiegler 14 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Ram Prakash Duraisamy 5,593 Super User 2025 Season 2 on at

Like (1)

Report

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

Was this reply helpful? Yes No
PowerBeeEye 7 on at

Like (0)

Report

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

searchable.png

Was this reply helpful? Yes No
Bipin D365 971 on at

Like (1)

Report

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!

Was this reply helpful? Yes No