Dataverse Tables not visible in PowerBI

(0) Share

Report

Posted on by carl1to

208

Hi community

Some custom tables of my power platform environment are not visible in PowerBI Query.

For example "mag_budgetposition"

What I tried:

- Connect with different accounts (both are Environemnt System Admins)

- Cleared all data source permission in PowerBi

Any ideas?

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (5)

Answers (1)

pavanmanideep 495 Power Up Champ - 2025 on at

Like (0)

Report

Hi @carl1to

May I know how are you connecting to your environment from Power BI?

Hope this helps…

If I have answered your question, please mark your post as Solved.
If you like my response or got a direction forward to proceed, please give it a Thumbs Up at least. Appreciate your Kudos. You can accept more than one post as a solution.

If you were still facing any issue or challenge, please do let me know so that I can try to check for you. Happy to help you further.

Blog: https://ecellorscrm.com

Cheers,
PMDY

Was this reply helpful? Yes No
AhmedSalih 6,678 Moderator on at

Like (0)

Report

Hello, @carl1to, are you using the Dataverse connector or the Legacy CDS connector?

Was this reply helpful? Yes No
carl1to 208 on at

Like (0)

Report

@Pavan_Mani_Deep , @AhmedSalih
Thank you for your reply. I'm using the Dataverse connector

TDS is set up for the environment in question. I think, otherwise I wouldn't get any tables:

Was this reply helpful? Yes No
pavanmanideep 495 Power Up Champ - 2025 on at

Like (0)

Report

Hi @carl1to

I wrote a blog post on how to connect to your Dataverse instance using SQL

https://ecellorscrm.com/2023/08/09/connecting-to-your-dataverse-instance-to-run-sql-queries-without-using-xrmtoolbox/

Can you try this way and see if you were able to see those tables?

Hope this helps…

If I have answered your question, please mark your post as Solved.
If you like my response or got a direction forward to proceed, please give it a Thumbs Up at least. Appreciate your Kudos. You can accept more than one post as a solution.

If you were still facing any issue or challenge, please do let me know so that I can try to check for you. Happy to help you further.

Blog: https://ecellorscrm.com

Cheers,
PMDY

Was this reply helpful? Yes No
Verified answer

carl1to 208 on at

Like (1)

Report

Thank you for your recommendation.
But it feels strange, that the native Dataverse connection should not work when Dataverse is literally THE database of Power Platform!

After a few tryouts I finally found the solution:
Deactivate TDS of the environment and activate it again --> tables appears! (Microsoft Magic ;-))

Was this reply helpful? Yes No