Forum Discussion

Impactful Individual

8 years ago

Solved

Export Data - Data Exceeds the Limit

Hi, I suspect this comes with the November update. When I try to do an Export Data from a Matrix or Table I am now getting a Data Exceeds the Limit error, I used to be able to Export data with a ...

TomMartens
8 years ago
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

New Member

4 years ago

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

Frequent Visitor

4 years ago

Thank you, thurein!
Your solution worked liked a charm to me!

Finally I can continue my analysis!!!