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

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

 

Thanks

Jeff