Forum Discussion
Microsoft EmployeeDataMashup file no longer exists
Power BI TeamYou'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.
Microsoft EmployeeTried 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.
Facing same issue, DataMashup file is not part of the package anymore, and I can't decode DataModel (it's encrypted?), any luck?
- mwegener
Most Valuable Professional
Hi slavikgl,
have a look at my Export2Dataflow solution.
Here I use PowerShell to extract the M code from Power BI Desktop and save it in a Dataflow format.
Maybe the example will help you for your requirement.https://github.com/MarcusWegener/Export2Dataflow
