Exporting native query for documentation

[Anonymous]

I am looking for a solution either on the service or desktop to allow me to open up the power bi report, grab the native query, and dump that text to a location (file, sharepoint list, table). The purpose is to catalog the final queries used and see where similarities lie which we could improve over time (common queries, improved performance). 

I am also looking to do this in Power Automate but pyton, c#, R are all acceptable solutions. 

[Anonymous]

Thanks. Let me try this.

[Anonymous]

This gets me the DAX query for sure. Now if we can find a way to automate it. 

[Anonymous · Accepted solution]

Hi @Anonymous - In Power BI Desktop, the Performance Analyser will capture the statistic of Query Runtime.  Introducing the Power BI Performance Analyzer - SQLBI.  These results across all visuals and pages can be exported in a JSON file.  There are Power BI tools that load the JSON to show details of about the visual refresh speed.   Importing Performance Analyzer data into DAX Studio - SQLBI or Review Performance Analyzer in this Power BI Report from Smart Power BI - YouTube.