Update OLAP Query

[hansei]

I was about to post a question, but discovered a solution if others have the same issue...

I have a Power BI model that is published to our workspace in the Power BI service. The dataset is then consumed by an Excel file for end users without service access. (Using Power BI plugin - Connect to Data)

With major changes, a new name is given to the model file, and to the corresponding report/dataset. e.g. from Charges1 to Charges2 (As such, backwards compatibility does not need to be strictly maintained. So somebody consuming Charges1 will not be impacted if Charges2 contains errors or a completely different schema. When ready for consumption, they can just be provided with a new Excel file that consumes the new dataset.)

I was facing the challenge of having to recreate all of the pivot tables, formulas, locations when updating the Excel files and adding a new connection, but the query turns out to be simple enough to update.

The query contains 2 UUIDs. The first one (repeated twice) is the service workspace (which may or may not need to change depending on whether you have changed the publication location) and the second is for the actual dataset (e.g. Charges2). Both of them can be copied from the service URL when the dataset is opened which takes the form of

https://app.powerbi.com/groups/<workspace-uuid>/datasets/<dataset-uuid>

Note that if you are consuming a published report rather than a dataset, the UUID is different for the same model.

[hansei · Accepted solution]

Question is Answer

[Anonymous]

HI @hansei ,

AFAIK, power bi query tables not support to dynamic update data structure.
If your data source structure changes and not match with original query table, it will return error and notice fields and keys not matched.

If your data sources have same structure, you can consider to parametrized your query then you can simply change these parameter on power bi service side.

Using the Power BI Service Parameters to change connection strings (To possibly change between Dev

Regards,

Xiaoxin Sheng