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

Like (0) Share

Report

Posted on 17 Apr 2023 13:59:43 by Community Power Pla...

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:

Process Advisor

All responses (6)

Answers (0)

Community Power Pla... on 24 Apr 2023 at 12:25:15

Like (0)

Report

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

this formula is just to calculate the number of loops needed !
lbendlin 7,863 Super User 2025 Season 1 on 24 Apr 2023 at 11:53:59

Like (1)

Report

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

This seems to be your culprit

Modify the bucketing formula.
Community Power Pla... on 24 Apr 2023 at 10:47:14

Like (0)

Report

Re: Export data from my Power BI dataset +1M rows to a CSV file on SharePoint with a Scheduled
lbendlin 7,863 Super User 2025 Season 1 on 18 Apr 2023 at 11:20:37

Like (1)

Report

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

Show your flow steps if possible.
Community Power Pla... on 18 Apr 2023 at 08:51:47

Like (0)

Report

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

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 7,863 Super User 2025 Season 1 on 17 Apr 2023 at 23:11:32

Like (1)

Report

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

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.