cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Microsoft
Microsoft

DataMashup file no longer exists

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?

9 REPLIES 9
Super User IV
Super User IV

Hi @yifguo ,

 

maybe that will help you.

https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-enhanced-dataset-metadata

 

 

Did I answer your question?
Please mark my post as solution, this will also help others.
Please give Kudos for support.

I work at KUMAVISION AG , one of the world's largest
implementation partners for Microsoft Dynamics. #BetterTogether
"Get the most out of data, with Power BI."
twitter - LinkedIn - YouTube - website

Microsoft
Microsoft

Hi @yifguo ,

 

The DataMashup file are not removed in pbix file for latest PowerBI client. How did you create the pbix file?

Capture.PNG

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Best Regards,

Dedmon Dai

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

 

Best Regards,

Dedmon Dai

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?

Power BI Team
Power BI Team

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.

Frequent Visitor

@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.

Helpful resources

Announcements
November Update

Check it Out!

Click here to read more about the November 2020 Updates!

Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

secondImage

Power Platform October Community Highlights

Check out the top community contributors across all of the communities

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors