Rob Jarrett on 28 Feb 2022 16:39:30
We are consistently finding situations where the meta data in a PBIX that contains the list of tables, views and columns does not update automatically and it generates errors that cannot be resolved. These errors express themselves in the Power Query Editor. I cannot seem to insert the screenshots here, so I refer to the link that illustrates the topic.
Re: Meta Data Errors - How can I refresh the meta ... - Microsoft Power BI Community
If the solution exists, I have not found anyone who knows what it is.
This is actually pretty basic stuff and Microsoft needs to give us a way to eliminate errors that arise from its poor management of meta data. When a table/view gets added to a data source, we should be able to force Power BI to refresh its inventory somehow.
The "Refresh" seems to do it, sometimes. But, it is definitely erratic. Once the meta data is refreshed, the errors go away. It is just bad practice to deploy things to production that have errors of this kind. It may be pulling data, but it is simply bad practice. We should have 100% confidence in the dataset we publish.