Unable to connect to Application Insights

[rowlandshaw]

When trying to conenct to Applciation Insights, I'm constantly seeing an error:

Failed to update data source credentials: The credentials provided for the ApplicationInsights source are invalid. (Source at https://management.azure.com/subscriptions/<my subscription guid>/resourcegroups/<my resource group>...)Hide details

Activity ID:	2ced8418-9915-4276-9d95-04c2359c3afb
Request ID:	8f9f4065-601e-34fb-aa0d-3efa9baaaaac
Status code:	400
Time:	Wed Oct 24 2018 08:46:07 GMT+0100 (GMT Summer Time)
Version:	13.0.7055.182
Cluster URI:	https://wabi-europe-north-b-redirect.analysis.windows.net

I can log into the Azure portal fromt he same browser and account with no problems.

This certainly used to work, as I have some datasets connected to App Inights from the same azure subscription that still work fine.

Any ideas of what I should check (other than the usual private mode, different browsers, etc. that I've already attempted)?

[artur]

Hi all,

did you understood what is the problem?

I have the very same error message...

[rowlandshaw · Accepted solution]

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-queries

If 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...)
* 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-E...)

[artur]

Thanks rowlandshaw,

so no way to get what were the tables and fields used in the ootb appinsight app in powerbi?

thanks

[rowlandshaw]

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)

[v-shex-msft]

Hi @rowlandshaw,

I check your request id and it seems like a common 'invalid connection credentials' error.

Spoiler

Exception object created: Microsoft.PowerBI.ServiceContracts.PowerBIRemoteServiceException: PowerBI service client received error HTTP response. HttpStatus: 400. PowerBIErrorCode: DM_GWPipeline_Gateway_InvalidConnectionCredentials

Event: NotifyPowerBIHttpOperationFailed (requestMessageTrace=Status=400 Bad Request, ContentHeaders=Content-Length:1762;Content-Type:application/json; charset=utf-8, ResponseHeaders=RequestId:8f9f4065-601e-34fb-aa0d-3efa9baaaaac;Date:Wed, 24 Oct 2018 07:46:07 GMT;Server:Microsoft-HTTPAPI/2.0, exception=PowerBI service client received error HTTP response. HttpStatus: 400. PowerBIErrorCode: DM_GWPipeline_Gateway_InvalidConnectionCredentials)

I'd like to suggest you open a support ticket and use fiddler to trace detail httprequests as detail contents to get better support.

submit a support ticket

Regards,

Xiaoxin Sheng

[rowlandshaw]

Have done now - was just wanting to check I hadn't missed anything silly 🙂 Just seems odd tas this definitely used to work for me, as I have a dashboard from a different App Insights instance within the same Azure subscription in my workspace...

[rowlandshaw]

[Mostly for the benefit of other people that experience this issue in the future]

Current working theory is that this is related to MFA, which we have set up on our O365 tennancy (although as the authorisation is done via OAuth, I would expect this to still work)

[Anonymous]

Thanks for this @rowlandshaw. Did you ever find a solution to this with MFA still turned on? I seem to be running into the exact issue.