Forum Discussion
Unable to connect to Application Insights
- The response I got back from support just this week was that this method is deprecated, and I should export an M query from App Insights, and consume that in Power BI instead (i.e. build all the reports again from scratch) - https://docs.microsoft.com/en-gb/azure/azure-monitor/app/export-power-bi#export-analytics-queriesIf you need to refresh your data more than the 8 times a day that this will limit to (as an Import data source), I'd instead suggest one of the following, all based on continuous export from App Insights to blob storage, you can then either:
* move the data to an on-premise server using Azure Data Factories (and build reports from there) https://docs.microsoft.com/en-us/azure/machine-learning/team-data-science-process/move-sql-azure-adf
* move the data to an Azure based SQL server using Stream Analytics (and build reports from there) https://docs.microsoft.com/en-us/azure/azure-monitor/app/code-sample-export-sql-stream-analytics (this does not work with on-premise servers, per https://social.msdn.microsoft.com/Forums/en-US/947e3891-ee53-4ce1-8f04-fb129847f4ba/unable-to-set-up-azure-stream-analytics-with-a-destion-of-an-onpremise-sql-server?forum=AzureStreamAnalytics)
* use PowerBI to read the files directly from blob storage (see also https://community.powerbi.com/t5/Integrations-with-Files-and/Azure-Application-Insights-Continuous-Export-to-Power-BI/td-p/203295)
Hi all,
did you understood what is the problem?
I have the very same error message...
- The response I got back from support just this week was that this method is deprecated, and I should export an M query from App Insights, and consume that in Power BI instead (i.e. build all the reports again from scratch) - https://docs.microsoft.com/en-gb/azure/azure-monitor/app/export-power-bi#export-analytics-queriesIf you need to refresh your data more than the 8 times a day that this will limit to (as an Import data source), I'd instead suggest one of the following, all based on continuous export from App Insights to blob storage, you can then either:
* move the data to an on-premise server using Azure Data Factories (and build reports from there) https://docs.microsoft.com/en-us/azure/machine-learning/team-data-science-process/move-sql-azure-adf
* move the data to an Azure based SQL server using Stream Analytics (and build reports from there) https://docs.microsoft.com/en-us/azure/azure-monitor/app/code-sample-export-sql-stream-analytics (this does not work with on-premise servers, per https://social.msdn.microsoft.com/Forums/en-US/947e3891-ee53-4ce1-8f04-fb129847f4ba/unable-to-set-up-azure-stream-analytics-with-a-destion-of-an-onpremise-sql-server?forum=AzureStreamAnalytics)
* use PowerBI to read the files directly from blob storage (see also https://community.powerbi.com/t5/Integrations-with-Files-and/Azure-Application-Insights-Continuous-Export-to-Power-BI/td-p/203295)Thanks rowlandshaw,
so no way to get what were the tables and fields used in the ootb appinsight app in powerbi?
thanks
a direct quote from my support case is:
This is to inform you that the content pack Application insights has been deprecated and you cannot load the data directly. To import your Application Insights query, you use the desktop version of Power BI. Then you can publish it to the web or to your Power BI cloud workspace and the only way to do it is from the scratch by creating a blank query and paste the exported M Language script into the Advanced Editor.
So no, you cannot use the content pack (you'll also note I also gave three other workarounds, that fitted my needs better)