Dataverse tables not showing up in Power BI

[nleuck_101]

Hello,

I can't find the Dataverse table that I created in Power BI. I've tried clearing the permissions 3 times and I still don't see the table. Any suggestions.

[v-xiaoyan-msft]

Hi @nleuck_101 ,

After creating the table, open the Dataverse table properties and click "save" without changing any settings. This action can sometimes help the table appear in Power BI when you refresh the connector panel.

Hope it helps！

Best Regards,
Community Support Team _ Caitlyn

[nleuck_101]

Hello @v-xiaoyan-msft 

Tried this and it didn't work. Why in world would Microsoft implement this functionality if it doesn't consistently work. I have nothing but issues with the connecting the Dataverse to Power BI. This is beyond frustrating. 

[DavidCetin]

Since the January Power Bi Desktop version update, I can't even find the Dataverse data connector! Not sure if this is an isolated incident or indeed the same problem.

Existing reports with Dataverse connections triggers the error to the right. Blank reports do not even facilitate a Dataverse connection. The shortkey button does nothing whilst the data source menu has the data connector literally missing.

[nleuck_101]

@DavidCetin 

I typed in Dataverse and here is what I have.

[DavidCetin]

I wish it was that easy...

What's your desktop app's version? I'm convinced it's an issue with the latest version.

[nleuck_101]

I have January 2025.

[OlahN]

I have the same issue with the (latest) 2025 February version. The same version is installed on my laptop and on an Azure VM and the Dataverse connector appears on laptop but not on the VM. I've reinstalled it but nothing changed.

[nleuck_101]

I found out what the issue was. We were using elastic tables for some and not standard. The elastic don't show up in the Dataverse connector. Which is kinda stupid in my opinion.

[DavidCetin]

The issue I had was to do with the power bi desktop app file being corrupted. But as for your point, I too learnt something new!

@nleuck_101 As for your discovery: I see where you're coming from, but you must understand 'Dataverse' (CDS) isn't just a database, it's a RDMS, storing data in different actual databases. It's like a hybrid Database. Naturally, as I understand, you have a data (API) connector for each data source. 1 for Excel, 1 for SharePoint Lists, 1 for Dataverse (standard) tables, etc.

I'll break it down for you a little:

• Regular (standard) tables store the data in the Azure SQL Database, which the dataverse connector works with.
• Elastic tables store the data in Azure Cosmos DB rather Azure SQL DB, which (I believe) requires the OData Feed connector.

https://community.dynamics.com/blogs/post/?postid=e8a488e6-4135-ef11-8409-6045bda70744 -- see under 'Limitations' I hope this at least explains why this is the way it is!

All the best mate 🫡