web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Copilot Studio / Fabric Data Agents to ...
Copilot Studio
Suggested Answer

Fabric Data Agents to Return Files For Rows >20

(0) ShareShare
ReportReport
Posted on by CU27021113-0 4
I have been playing with Fabric Data Agents and I think they are amazing.
 
People complain GenAI isnt consistent but with FDA generating SQL/DAX we have auditable, reliable results. However, sometimes the results return more rows than fits nicely in a chatbox.
 
I was hoping to setup some sort of workflow where if rows returned > 20 the agent gives the user the option to export to csv.
 
Not sure if this is doable or if anyone has done something similar to get around the row limitation in the chat.
 
Maybe get Fabric Notebooks to run the query FDA generates and then export to the Copilot Chat Files folder?
 
Thoughts?
 
Thanks
 
Richard
Categories:
General topics
I have the same question (0)
  • Suggested answer
    Karan_Shewale_MSFT Profile Picture
    Karan_Shewale_MSFT Microsoft Employee on at

     

    Yes, this is definitely doable! You can create a workflow where Fabric Data Agents trigger a Notebook to export large result sets to CSV.

    Implementation Approach:

    Step 1: Create Export Notebook
    Create a Fabric Notebook with this logic:

    • Execute the SQL/DAX query generated by the Data Agent
    • Check row count
    • If rows > 20, export to CSV
    • Save to Fabric Lakehouse Files folder
    • Return download link

    Step 2: Integration Options

    Option A: Manual Trigger

    • Agent displays message: "Results too large. Click here to export"
    • Link triggers the Notebook with query parameters

    Option B: Automated Workflow

    • Use Fabric REST API to trigger Notebook automatically
    • Return download link in agent response

    Step 3: File Access
    Export to one of these locations:

    • Fabric Lakehouse Files
    • OneDrive for Business
    • SharePoint document library

    Practical Tips:

    • Consider adding row count preview in chat before export
    • Set up scheduled cleanup for old CSV files
    • Add user-specific folders for multi-user environments
    • Keep the SQL/DAX query visible for auditability

    Current Limitations:

    • No native "export" button in Data Agents yet
    • Requires custom orchestration between Agent and Notebook
    • File permissions need to be managed separately

    Reference Documentation:

    Feature Request:
    This would be a great enhancement! Consider submitting feedback through the Fabric Ideas forum at https://ideas.fabric.microsoft.com The Notebook approach maintains the auditability you mentioned since you're using the exact same SQL/DAX queries the agent generates, just executing them in a different environment for export purposes.

    Thanks 

    Karan Shewale.

  • CU28060040-0 Profile Picture
    CU28060040-0 2 on at
    Hi Karan,
     
    Thank you for sharing this solution. 
     
    To Microsoft,
     
    Why set limitation on the returned rows to this low number? You are blocking Data Agent adoption... People will choose DataBricks or Snowflake instead. Please consider increasing the results at least over 100 or more rows

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Copilot Studio

#1
Valantis Profile Picture

Valantis 277

#2
11manish Profile Picture

11manish 206

#3
sannavajjala87 Profile Picture

sannavajjala87 156 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Announcing the "Microsoft Copilot Studio ❤️ MCP" lab
Block PII/PCI in Copilot Studio agent user prompt

Product updates

Microsoft Power Platform Community release plans