Forum Discussion

elementaryraja's avatar
elementaryraja
Regular Visitor
7 years ago
Solved

Download/Export all queries [SQL statements] from Power BI Desktop

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 st...
Need Help
  • v-piga-msft's avatar
    v-piga-msft
    7 years ago

    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

v-piga-msft's avatar
v-piga-msft
Resident Rockstar
7 years ago

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

Bal_Singh's avatar
Bal_Singh
Helper I
1 year ago

Hi v-piga-msft ,
I followed your steps but in my case I don't see the folder 'DataMashup' unfortunately. Any thoughts please? Thanks.