You’re offline. This is a read only version of the page.
202
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?
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 ;-))
Hi @carl1to
I wrote a blog post on how to connect to your Dataverse instance using SQL
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
@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:
Hello, @carl1to, are you using the Dataverse connector or the Legacy CDS connector?
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
#1
mmbr1606
22
Super User 2025 Season 1
#2
stampcoin
19
#3
Michael E. Gernaey
15
Super User 2025 Season 1
Share
Report
All responses (
Answers (
