Our team is leveraging a tool to extract PowerM query from DataMashup file in pbix files. But the DataMashup file no longer exists in the pbix generated by latest PowerBI client. Where is the file moved to? If it no longer exists, how can we extract PowerM query from pbix file?
You're correct. The Enhanced dataset metadata preview changes the way we save the pbix file. The DataMashup is no longer saved in the pbix if the model and queries are in sync, and instead we regenerate the Mashup on open. All of the metadata that was in the Mashup is now saved in the data model, so you should be able to get the M expressions from the data model now instead.
Tried to find the Power M queries from data model, but seems that the file was encrypted. Could you help me figure out how to extract the queries from data model? Thanks.
@yifguo have you found a way to extract queries from model, when "Store datasets using enhanced metadata format" is ticked?
What tools are/were you using? We are facing similar issue and trying to find a way to extract and rewrite data in this file.
I am also trying to figure out how to extract the datamodel in a stand alone tool and haven't been able to get it loaded. Would love to hear if anything works for you guys.
Hi @yifguo ,
The DataMashup file are not removed in pbix file for latest PowerBI client. How did you create the pbix file?
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
The version of power BI I am using is
Version: 2.82.5858.602 64-bit (June 2020)
The .pbix files it generates do not contain DataMashup file.
Hi @yifguo ,
How did you get version 2020 June? What I can get is the version of 2020 May, please try to use this version: https://www.microsoft.com/en-us/download/details.aspx?id=58494
Maybe I am on the insider ring? But I think the version doesn't really matter, as https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-enhanced-dataset-metadata states, it will finally move to enhanced dataset. So my question is, how to extract the powerM query when enhanced dataset is turned on?
This is a must watch for a message from Power BI!
Click here to read more about the December 2020 Updates!
Click here to read the latest blog and learn more about contributing to the Power BI blog!
Mark your calendars and join us for our next Power BI Dev Camp!.