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
I am having this same issue. It sounds like you've confirmed it will not truncate the data at least up to 10,000 records, but how do we know for sure when receiving the error. We're supposed to be able to download 150,000 records. I am unsure as to whether or not I have a complete data set when using this feature.
Every release of Power BI seems to result in more bugs. These new bugs every month waste so much time. It's really frustrating.
I'm facing the same issu with the Version: 2.56.5023.942 (March) . It seems a maximal number of rows which can be exported is 30000!
Yes, apparently. Also it's still is doing that thing where it removes duplicate columns, well different headers but the same content - not a good design but yes I really intended to put a duplicate column. PowerBI removes the twin column and leaves only one.
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
the documentation states that there is a limit of rows that can be exportet to csv, this limit is 30000 rows.
But, there is a way to retrieve the data from Power BI by using DAX studio software.
Install the software and Open both softwares, ( power BI and DAX studio ).
In a few seconds, DAX studio connect browser will appear, you have to choose one option ( PBI/ SSDT Model ) with your power BI file name.
IF connected, you can see the power bi data in home tab.
And you have to go to "Advanced Tab", Click Export Data. Choose the CSV file and Output file path.
Done.
Enjoy the 30000 plus rows data.
Here is the link for DAX studio software.
https://www.dropbox.com/s/yh7vuwweuw9tco7/DaxStudio_2_16_2_setup.rar?dl=0
