Share via

"Run a Query Against dataset" tool returns 400 error.

Satyabrata Samanta [UNext] 5 Reputation points
2026-02-06T05:52:37.9633333+00:00

Hey,

I was using "run a query against dataset" power bi tool in copilot studio agent. My agent writes correct DAX query and sends it to the "run a query against dataset" tool and fetches the answer. But after 2 or 3 questions it says 400 error. When check the activity, the agent is passing correct DAX query to tool but tool is returning 400 error. Help me resolve this issue.

Microsoft Copilot | Other
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Q&A Assist
    2026-02-06T05:52:49.91+00:00
    AI generated content. This question contains an answer created with AI from Q&A Assist. Learn more

    The 400 error you are encountering when using the "run a query against dataset" tool in Copilot Studio may be related to the size of the data being returned. Copilot Studio limits connector responses to 500 KB, and if the request from the connector to the service returns too much data, it can trigger this error.

    To resolve this issue, you should consider filtering the responses returned to the connector. This can be done by configuring the inputs to the connector action so that the service returns only the necessary data required to respond to the user's request.

    Additionally, ensure that your DAX queries are optimized and not returning excessive amounts of data that could exceed the limit.

    0 comments

Your answer

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