Data Mashup Unzip

[Anonymous]

Hi,

I need to do some automation on the data mashup file and I was reading an article

https://radacad.com/exposing-m-code-and-query-metadata-of-power-bi-pbix-file

Here, it says that data mashup file is  a zipped file and it has 3 files in it

• Config
• Formulas
• content_types

But i'm not able to unzip this file. Any idea why?

[Anonymous]

Hi

I am trying to do something similar but once I modify the section.m file and try to zip it back, I am unable to open the .Pbix file. It says the file has been corrup. Any idea how to fix this @Anonymous ?

[Anonymous]

Your modification may be causing a problem for Power BI(pbix) to read it.

[Anonymous]

I am just modify a simple query section.

Before :

section Section1;

shared Query1 = let
Source = Oracle.Database("ABC", [HierarchicalNavigation=true, Query="select Employee_id from employees"])
in
Source;

After:

section Section1;

shared Query1 = let
Source = Oracle.Database("ABC", [HierarchicalNavigation=true, Query="select Employee_id,Email from employees"])
in
Source;

Is it possible to un-zip update this section.m file inside the DataMashup and zip it back and use it in pbix file? Any other workaround? 

[Anonymous]

Check how your editing the file. Check that the length change matches correctly with what you expected afterwared. I found that my editor (VS Code ) was adding a two Byte BOM on the front. I had to strip these to get modification to work. 

Jeff

[Anonymous]

Let me know if you work this out. I would also like to be able to do this.

Thanks

Jeff

[TeigeGao · Accepted solution]

Hi @Anonymous ,

Based on my test, we can use the 7-zip tool to extract the file rather than changing it as a zip file.

Best Regards,

Teige