Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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...
Need Help
Anonymous's avatar
Anonymous
Not applicable
4 years ago

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.