Querying Log Analytics using Kusto Connection in PowerBI causes error: Bad request : ApiContractViolation Error

Aidan Dowling 0 Reputation points
2023-06-26T13:13:38.02+00:00

When attempting to make a connection, the general query succeeds but fails when the data refreshes.

User's image
User's image

Azure Data Explorer
Azure Data Explorer
An Azure data analytics service for real-time analysis on large volumes of data streaming from sources including applications, websites, and internet of things devices.
577 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. QuantumCache 20,366 Reputation points Moderator
    2023-06-26T17:28:55.5066667+00:00

    Hello @Aidan Dowling, Thanks for reaching out on this forum

    the general query succeeds but fails when the data refreshes.

    What is the general query? is it from Desktop during the development phase?

    During Data Refresh--The error might be due to the Schema changes in the source ? such as mis-match in column names, count, not-found etc,

    Suggestion would be to try with a simple query from a different Cluster and Database from the one you are trying to access and see if the issue still persists.

    Azure Data Explorer connector for Microsoft Power Automate

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.