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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Export data from my Po...
Power Automate
Unanswered

Export data from my Power BI dataset +1M rows to a CSV file on SharePoint with a Scheduled

(0) ShareShare
ReportReport
Posted on by

Hello, I'm trying to export data from my Power BI dataset to a CSV file on SharePoint. My Dataset contains over 1 million rows, and I've tried adding an 'index_' column using RANKX based on an ID column. However, when I export the data to a CSV file, I only get 2000 rows in the output. I need help with this issue. Can you please provide some guidance on how to export the full dataset to a CSV file on SharePoint? Thank you. @RPAForEveryone 

Categories:
I have the same question (0)
  • lbendlin Profile Picture
    8,474 Super User 2025 Season 2 on at

    That is a known limitation. 100K rows or 1M cells, whatever comes first.

     

    Do multiple exports and concatenate them. Note that CSV has a similar limitation. Maximum message size is 100 MB.

  • Community Power Platform Member Profile Picture
    on at

    please how can I minimize the size of the CSV in the output?
    i try many of time but i got only 2000 rows, i have used DO UNTIL, but it still return only 2000 by csv!

  • lbendlin Profile Picture
    8,474 Super User 2025 Season 2 on at

    Show your flow steps if possible.

  • Community Power Platform Member Profile Picture
    on at

    Screenshot 2023-04-24 114330.pngScreenshot 2023-04-24 114534.pngCOM1.png

  • lbendlin Profile Picture
    8,474 Super User 2025 Season 2 on at

    This seems to be your culprit

     

    lbendlin_0-1682337226998.png

     

     

    Modify the bucketing formula.

  • Community Power Platform Member Profile Picture
    on at

    this formula is just to calculate the number of loops needed !

     

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

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 538 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 405 Moderator

#3
abm abm Profile Picture

abm abm 252 Most Valuable Professional

Last 30 days Overall leaderboard