Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I would like to analyse powerBI desktop report which has more than 50 queries [importing data from SQL server with complex SQL statements]. I was able to download all columns and measures with DAX studio and would like to export all sql queries instead of manually opening up through "Edit Queries".
Thanks
Solved! Go to Solution.
Hi @elementaryraja ,
Please follow the steps below.
1. Extract the pbix file and then find the Datamashup
2. Extract the DataMashup
3.Find the Formula folder and find the Section1 file and open it with Notepad.
Best Regards,
Cherry
Could you please provide an updated version of this answer? Thank you in advance.
One way:
1. Make a copy of the PBIX.
2. Change the extension to zip
3. open the DataMashup file with notepad.
4. search for: Query=
It will not be formatted nicely, though.
I renamed as zip file and opened it up with notepad, but still couldn't find query
Hi @elementaryraja ,
Please follow the steps below.
1. Extract the pbix file and then find the Datamashup
2. Extract the DataMashup
3.Find the Formula folder and find the Section1 file and open it with Notepad.
Best Regards,
Cherry
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
97 | |
85 | |
67 | |
59 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |