Solved: CSV export limit

Omega · ‎02-13-2018

What is the maximum number of rows when exporting to csv?

v-chuncz-msft · ‎02-13-2018

As mentioned here, the maximum number of rows that can be exported from Power BI Desktop and Power BI service to .csv is 30,000.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

v-chuncz-msft · ‎02-13-2018

@Omega,

As mentioned here, the maximum number of rows that can be exported from Power BI Desktop and Power BI service to .csv is 30,000.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous · ‎08-27-2018

Hello,

You may have a look at this project where you can export an xlsx file semi automatically. Limit is 150 000 lines (limit of the visuals):

https://github.com/didierterrien/Power-BI-assistant

Best regards

Greg_Deckler · ‎02-13-2018

I believe it is 150,000 rows: https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/11339772-export-data-limit-to-inc...

Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: DAX For Humans

DAX is easy, CALCULATE makes DAX hard...