Forum Discussion
Exporting native query for documentation
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 pu...
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.
Thanks. Let me try this.
This gets me the DAX query for sure. Now if we can find a way to automate it.