Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

View all the Fabric Data Days sessions on demand. View schedule

nleuck_101

Dataverse tables not showing up in Power BI

Submitted by Responsive Resident on ‎01-14-2025 12:06 PM

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.

Status: Investigating
See more ideas labeled with:
9 Comments (9 New)
Comments
Anonymous
Not applicable
‎01-14-2025 09:33 PM

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
Responsive Resident
Responsive Resident
‎01-15-2025 05:14 AM

Hello @Anonymous 

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
Regular Visitor
‎01-16-2025 05:06 AM

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.

DavidCetin_0-1737032686573.png

DavidCetin_1-1737032727620.png

 

nleuck_101
Responsive Resident
Responsive Resident
‎01-16-2025 05:19 AM

@DavidCetin 

I typed in Dataverse and here is what I have.

nleuck_101_0-1737033545423.png

 

DavidCetin
Regular Visitor
‎01-16-2025 05:25 AM

I wish it was that easy...

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

 

 

nleuck_101
Responsive Resident
Responsive Resident
‎01-16-2025 05:33 AM

I have January 2025.

OlahN
New Member
‎03-05-2025 04:49 AM
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
Responsive Resident
Responsive Resident
‎03-20-2025 05:38 AM
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
Regular Visitor
‎03-20-2025 05:53 AM

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 🫡

Idea Statuses