Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Data Mashup Unzip

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 mas...
Need Help
  • TeigeGao's avatar
    TeigeGao
    7 years ago

    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

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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's avatar
Anonymous
Not applicable
4 years ago

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