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

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?

Super User II
Super User II

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

Helpful resources

Announcements
secondImage

Happy New Year from Power BI

This is a must watch for a message from Power BI!

December Update

Check it Out!

Click here to read more about the December 2020 Updates!

Community Blog

Check it Out!

Click here to read the latest blog and learn more about contributing to the Power BI blog!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors
Top Kudoed Authors