Forum Discussion
datasource change taking forever
When you changed the connection Power BI panicked and threw away all the meta data it had accumulated for the prior setup. Now it is starting over and collecting all the meta data anew. I really wish they would find a better way to do this.
Super UserWhen you changed the connection Power BI panicked and threw away all the meta data it had accumulated for the prior setup. Now it is starting over and collecting all the meta data anew. I really wish they would find a better way to do this.
Thank you, what exactly is "metadata" and where can I get more information about it ?
- lbendlin
It is information about the structure of the data, rather than the data itself. So it lists field types, field sizes, indexes, relationship keys etc. A semantic layer, if you will.
Is there a place that I can see this information ?
- lbendlin
Check the Power Query Value.* functions like
Value.Metadata - PowerQuery M | Microsoft Docs
Value.Is - PowerQuery M | Microsoft Docs
Value.Type - PowerQuery M | Microsoft Docs
Also, Ben Gribaudo has an excellent series of articles about the darker corners of Power Query, including Metadata.