Forum Discussion

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

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

6 Replies

TeigeGao
Solution Sage
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
Not applicable
6 years ago
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
  Not applicable
  6 years ago
  Your modification may be causing a problem for Power BI(pbix) to read it.
  - 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?