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 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.
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.
3 Replies
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.