MS FLOW - Application Insight("Run Analytics Query") Suddenly Stopped Working

[ronenB]

After almost 2 months since the flow was created, it now fails every hour.

Under the block of "Run Analytics Query", there is an error which says

Unauthorized.

On the right panel(on failed flow) its written:

Action 'Run Analytics query' failed

Fix It

You should be able to fix this by verifying your account with Azure Application Insights. You may need to re-enter your password.

Error type

This action failed because the connection '***********' is not authorized.

Error Details

The error message from the service is below. This maybe useful for support:

The response is not in a JSON format.

I've tried to generate new API key for the Application Insights resource, same problem.

I'll apreciate your help.

Thanks.

[v-yuazh-msft]

Hi @ ronenB,

Could you please share a screenshot of the configuration of your flow?

Which action run failed in your flow with error Unauthorized?Is it "Run Analytics Query" action of "Azure Application Insight" connector?

The error message told that the connection of "Run Analytics Query" action is expired and the error is a authentication failures.

In many cases, flows fail because of an authentication error. If you have this type of error, the error message contains Unauthorized or an error code of 401 or 403 appears. You can usually fix an authentication error by updating the connection:

1. At the top of the web portal, click or tap the gear icon to open the Settings menu, and then click or tap Connections.

2. Scroll to the connection for which you saw the Unauthorized error message.

3. Next to the connection, click or tap the Verify password link in the message about the connection not being authenticated.

4. Verify your credentials by following the instructions that appear, return to your flow-run failure, and then click or tap Resubmit.

   The flow should now run as expected.

You could refer to link below to learn more about troubleshooting the flow errors:

https://docs.microsoft.com/en-us/flow/fix-flow-failures

Please let me know if your problem could be solved.

Regards,
Alice Zhang