Skip to main content

Power BI

New

Export to CSV

Vote (65) Share
Ivan's profile image

Ivan on 14 Jan 2020 03:40:35

Hello,
In https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/9609906-export-powerbi-desktop-to-csv-excel its been reported that export to CSV is implemented.

Unfortunately its very limited aka you can't export more than 30k rows.

Considering the fact that PBI can import hundred of thousands of rows its pretty strange that it can export only 30k rows...

I believe that a lot of people out there working with huge datasets and doing extensive ETL operations and this feature is really needed.

Also you can't export from Data tab, only from visuals which is very limiting.

Please consider to make export limit only dependent on RAM available without artificial limitations. Thanks!

Comments (3)
Ivan's profile image Profile Picture

7bc0aefe dfd4-4c2b-a578-c72982210737 on 06 Jul 2020 00:16:21

RE: Export to CSV

Although I Voted here, but since I could not export from desktop, I thought it is not possible from Service also. But this is not the same. I think, service can export data more than 30k limit.
My concern was export limit from service which is already available.

Ivan's profile image Profile Picture

5c04c441 a38d-417c-a6b7-faf2172af473 on 06 Jul 2020 00:08:37

RE: Export to CSV

The limitation must be eliminated and the capability to automate the export of a visualization summary must be provided.

The possibilities are so huge if this can be done.

And Yes, using PBI as an ETL platform with automation via DAX R etc would be so killer!

Ivan's profile image Profile Picture

6b053dda 87ab-448a-935f-adea13fb5f4a on 06 Jul 2020 00:08:09

RE: Export to CSV

This is the same issue as the link below which has more votes already

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/31837054-don-t-limit-download-data-file-sizes?page=1&per_page=20