Forum Discussion

margaretaak's avatar
margaretaak
Frequent Visitor
10 months ago
Solved

Fabric Data Agent Only Returns 25 Rows

I want to display the revenue per category per month in 2024. There are 3 categories and 12 months. When I do a query in SQL Analytics endpoint, it returns 36 rows in full. However, when I do a promp...
data hub
one lake
workspaces
  • v-hashadapu's avatar
    v-hashadapu
    9 months ago

    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.

v-hashadapu's avatar
v-hashadapu
Community Support
9 months ago

Hi margaretaak , hope you are doing great. May we know if your issue is solved or if you are still experiencing difficulties. Please share the details as it will help the community, especially others with similar issues.