Forum Discussion
Tables from Dataverse not showing up
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.
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.