Skip to main content
Community site session details

Community site session details

Session Id : bsBouNgtaVr2aUrcPgu/Rv
Power Automate - Using Connectors
Unanswered

Application Insights Flow query can't run cross-app unions \ queries

Like (0) ShareShare
ReportReport
Posted on 1 Aug 2019 12:59:07 by Microsoft Employee

known issue?

 

I've tried following https://docs.microsoft.com/en-us/azure/azure-monitor/log-query/unify-app-resource-data so I've built the query referencing multiple apps but I just get a 400 error (really descriptive):

 

union withsource=SourceApp app('Contoso-app1').requests, app('Contoso-app2').requests

| take 10

 

run results:

 

status code: 400

body:

{
"Message": "An error has occurred."
}

 

I've got apiKey access to my apps, and I notice i can access the app() which the key is associated with, but not unions. since I can only associate a single connection with the flow action, hence a single Key - I cannot associate more than one. It's documented that access should exist - regardless of this, so this makes the function pretty useless in this case.

 

there's some mention of this issue in https://social.msdn.microsoft.com/Forums/sqlserver/en-US/a6cad12d-03e6-4383-bd44-fd13b299316d/querying-multiple-application-insights-instances-from-quotrun-analytics-queryquot-step?forum=azurelogicapps&prof=required 

 

please advise.

 

thx

  • Avi Profile Picture
    Microsoft Employee on 05 Aug 2019 at 09:29:55
    Re: Application Insights Flow query can't run cross-app unions \ queries

    Capture.PNG

    screen shared above. pretty simple. as mentioned earlier - i have one connection set up with the appId of one of the apps + ApiKey.

    All the apps are under the same subscription which i have access to. This works just fine if running it in the azure portal in the Log Analytics pane for App insights. It also runs just fine if exported as a PowerBI connection (M query).

    I can probably share more in a private session - can have a live debug session if you'd like.

    I also tried creating a 'union' function in app-insights as part of one of the apps instead, and calling just the function from FLOW - same result.

    thx

  • v-alzhan-msft Profile Picture
    on 02 Aug 2019 at 05:13:47
    Re: Application Insights Flow query can't run cross-app unions \ queries

    Hi @Avi ,

     

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

    Please share more details so we could reproduce the issue and provide a proper workaround for you.

     

    Best regards,

    Alice       

     

    Community Support Team _ Alice Zhang
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Featured topics

Loading complete