Forum Discussion

BourbonCoffee's avatar
BourbonCoffee
Frequent Visitor
2 years ago

How to get the Power Query M Code for multiple PBIX Files?

Hi,   I've tried serveral approaches to get the Power Query M Code definitions from nearly 100 PowerBI reports, unsuccessfully. We've started to do it manually, but if someone of you happened to kn...
Need Help
rubayatyasmin's avatar
rubayatyasmin
Community Champion
2 years ago

Hi, BourbonCoffee 

 

try to use Power BI helper (third party free tool). 

 

refer: Export the Entire M Power Query Script from a Power BI File, New Version of Power BI Helper, Search based on Field Description in the Model - RADACAD

 

Also, there is another tool available on syncopq on github. This tool helps to extract M code form a PBIX file. 

 

refer: GitHub - Seddryck/syncopq: Extract the Power Query/M code from a .pbix file, parse the content of this unique file to create one file by query and prepare a PowerShell script to deploy the queries to a Power BI Dataflow.

 

I hope this helps