Fabric Data Agent Only Returns 25 Rows

Hi margaretaak , Thank you for reaching out to the Microsoft Community Forum.

You’re right, the Fabric Data Agent isn’t meant to act like a full data endpoint. It’s designed for conversational insights, not for returning complete datasets. As a result, it automatically limits or summarizes rows in its chat responses to keep things concise and performant.

If you need to visualize all 36 rows, the best approach is to have the agent store your query results in a Lakehouse table or dataset, then connect Quickchart or Copilot Studio directly to that source so you can work with the full dataset.