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
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
Thank you, thurein!
Your solution worked liked a charm to me!Finally I can continue my analysis!!!
- How do I change export format to excel?
Hello,
still get the same issue with version of april 2019 .... the data are troncated at 30000 rows for csv files from the desktop .... i don't understand what is the idea behind limiting the file size but it's clearly painful
i've heard that i should be able to export to XLSX from the sevice (up to 150000 row) but i couldn't find the option
Can you help me?
thanks
Thanks, but that is definitely new information and I think everyone who came to this thread aren't aware. Prior to November update there was no such limitation.
Okay then I think I rest my case, though I'm curios WHY.
Limits it is!
Just updating the new URL from TomMartens answer
Hi, I'm aware of the 30,000 row limit. But I'm trying to export tables that are far under 30,000 rows and still getting the "data exceeds the limit" error. Any other known reasons for this or workarounds? Thanks.
Hey Anonymous and Ben-Day ,
there is a current issue, you can find it here on the Power BI tab: https://support.fabric.microsoft.com/de-de/known-issues
Regards,
TomI'm having the same issue. The data is under 30,000 rows.
Could this be an issue introduced with the latest release?
The link is no longer available.
