how can I export the azure virutal desktop insight reports to powerbi?

Question

I would like to share the Azure Virtual Desktop Insight reports with management who doesn't have admin accounts and cannot access the azure portal.

I know that I can export kql queries to PowerBI, but I didn't find any way to export the Insight reports (or the queries behind the charts) to PowerBI.

How can I export these queries the most simple way?

Answer 1

Hello Vilmanyi, Marton

I apologize for the confusion. Unfortunately, there is no direct way to export the queries behind the Azure Virtual Desktop (AVD) insights reports to Power BI. However, you can use the following workaround to extract the queries:

1. In the Azure portal, go to your AVD workspace.
2. Under Monitoring, select Insights.
3. Select the report you want to extract the query from.
4. Click the Export button and select "Export to Excel".
5. Open the exported Excel file and go to the "Data" tab.
6. Click "From Table/Range" to import the data into Power Query Editor.
7. In Power Query Editor, you can see the query that was used to generate the report under the "Applied Steps" section.
8. Copy the query and paste it into a new query in Power BI.

Note that the query may need to be modified to work in Power BI, depending on the data model and schema used in your Power BI report. Also, this method only works for reports that are generated using the "Export to Excel" feature in AVD insights. If the report was generated using a different method, such as a custom KQL query, this method may not work.

Hope this helps.