Forum Discussion
Solved
Refresh Power BI Metadata
Hello, I have a situation where I need to add new attributes to the Power BI Semantic Model (published to Service). Is there a way to refresh the metadata of a semantic model using an API or prog...
That's what ALM Toolkit does. Or you can go rogue and craft your own XMLA.
Hi SivaMani
- Use dynamic data sources in Power BI. This involves setting up your data source query to dynamically adapt to changes in the schema. For example, using SQL queries that select all columns (SELECT *) can help ensure new columns are automatically included.
- In Power Query, avoid hardcoding column names. Instead, use functions like Table.ColumnNames to dynamically reference columns.
- Set up data alerts and monitoring to notify you when new columns are added to the data source. This can help you stay informed and take necessary actions if needed.
As a side note - Power Query HATES data source changes. It will punish you with endless "Evaluating..." dialogues that you can either sit out or cancel (which will make it worse). So think twice before you go that route.