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

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

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

  • 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

    • 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