Forum Discussion
Tables from Dataverse not showing up
Created a table in Dataverse. If I go to Excel >Get Data from Dataverse. I can see the table.
I do the similar thing in PowerBI, Table does not show up in Power Query. The wierd thing is my old tables will show. things that were made, 2 weeks ago. showed up long enough for me to make a dashboard. but not i cant find it using the same method.
So just to be sure i wasnt hallucinating. I went back to my latest dashboard with, and went to transform. Table would not load
I wen to Excel again. Power Query can find the table without issue. Just Powerbi desktop cannot
Other tables in the same environment, set up in a similar fashion, just months older would be fine.
Thanks for the reply. but i actually somehow fixed it about 5 to 10 min ago. Your idea of cache seems accurate enough?
Im not sure i know enough about the TDS, but what it fixed it for me was
Opptions > Data load > Clear Cache on Data Cache and Folded Artifacts Cache. I feel like it was the second that fixed it, but im not sure i understand enough as to why that fixed it.
The Folded Artifacts Cache stores information Power Query uses about the source, including query folding and metadata. If that cached metadata becomes stale, Power BI may continue using an old list of Dataverse tables instead of fetching the latest metadata from the environment.
When you cleared:
- Data Cache – removes cached data used by Power BI.
- Folded Artifacts Cache – clears cached query folding plans and source metadata.
Power BI was forced to retrieve fresh metadata from Dataverse, which is why the missing table became visible again.
Since Excel could always see the table, it suggests the problem wasn't with Dataverse or the TDS endpoint itself, but with Power BI Desktop's local cache. The fact that clearing the cache resolved it is strong evidence that stale metadata was the root cause.
3 Replies
Most likely causes:
- Power BI Desktop metadata/cache issue.
- Outdated or buggy Power BI Desktop version.
- Using the wrong connector (use Dataverse, not Legacy or OData).
- TDS endpoint or Dataverse metadata synchronization issue.
- Table configuration or permissions (less likely since Excel works).
Thanks for the reply. but i actually somehow fixed it about 5 to 10 min ago. Your idea of cache seems accurate enough?
Im not sure i know enough about the TDS, but what it fixed it for me was
Opptions > Data load > Clear Cache on Data Cache and Folded Artifacts Cache. I feel like it was the second that fixed it, but im not sure i understand enough as to why that fixed it.
The Folded Artifacts Cache stores information Power Query uses about the source, including query folding and metadata. If that cached metadata becomes stale, Power BI may continue using an old list of Dataverse tables instead of fetching the latest metadata from the environment.
When you cleared:
- Data Cache – removes cached data used by Power BI.
- Folded Artifacts Cache – clears cached query folding plans and source metadata.
Power BI was forced to retrieve fresh metadata from Dataverse, which is why the missing table became visible again.
Since Excel could always see the table, it suggests the problem wasn't with Dataverse or the TDS endpoint itself, but with Power BI Desktop's local cache. The fact that clearing the cache resolved it is strong evidence that stale metadata was the root cause.