Forum Discussion
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.
Hi v-hashadapu
If that's the case, then it's no longer a fabric data agent. This means there's no way for a fabric data agent to display more than 25 records?
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.