Forum Discussion
Export Data - Data Exceeds the Limit
Hey,
the documentation states that 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:
https://docs.microsoft.com/en-us/power-bi/power-bi-visualization-export-data
Please don't ask me why such a limit exists :-) I'm just the messenger
Regards
Tom
Prabhu_MDUThere is a bit of a tricky gotcha to this. In order to see the export option (even the three dots for that matter), the Visual Header must be turned on, on the visual. So, in the desktop pbix file, click on the visual for which you want to be able to export and then go to the paint roller formatting pane. Look down at the bottom where it says Visual header and turn it on. Here's a screenshot. When you publish, the option (three dots) should now show upon hovering on the visual.
Shelley Hoorray... it works.. Thanks a lot..