Export Data - Data Exceeds the Limit

[gtamir]

Hi, I read somewhere that there shoul be a fix for this problem.

Do you know how to export big tables (visuales).

Giora

[marclelijveld]

Hi @gtamir

Lets start at your issue. Your exceeding the data export limit? 
First two questions; 
- Why would you like to export the data? 
- How are you exporting the data right now where you're exceeding the limit? 

Thanks, 
Marc

[gtamir]

I export from the 3 dots on the right upper side of the visual. I don't know how many rows in the report but I exported it anyway and got 30,000 rows.
I need to send this table to the customer and he prints it.

[v-danhe-msft · Accepted solution]

Hi @gtamir,

Based on my research, there is a limit of rows that can be exportet to csv, this limit is 30000 rows.

Using the target format xlsx this limit is 150k rows, the export to xlsx option is available in Power BI Service.

These limits are described here, you could refer to it:

https://docs.microsoft.com/en-us/power-bi/power-bi-visualization-export-data#limitations-and-conside...

Regards,

Daniel He