Get data from log analytics with system assigned managed identity

Question

Hi,

I have set up a connection to log analytics in ADF. I grant access to the Log analytics resource for data factory.

In a web activity it works fine and I see data in the activity, but in a copy activity I get empty results:

I am using the same authentication:

• System-assigned managed identity

endpoint:

• https://api.loganalytics.azure.com/v1/workspaces/<Log analytics workspaceID>/query

Microsoft Entra ID resource:

• https://api.loganalytics.io

Query:

{"query":"Table |take 10"}

Hope someone can help me with this.

Regards,

Ronald

Answer 1

Hi ,

Thanks for reaching out to Microsoft Q&A.

The image yo uhave attached shows that the 'copy activity' returns an empty tables array, while the web activity correctly returns data. This usually happens because ADF’s copy activity with REST connector expects a slightly different response format or there is a schema parsing mismatch.

If you just need the raw JSON for further processing, in copy source settings:

• Set 'Response format' to JSON
• Use $.tables[0].rows[*] as the collection reference

Can you try this and let me know?

Please 'Upvote'(Thumbs-up) and 'Accept' as answer if the reply was helpful. This will be benefitting other community members who face the same issue.