cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ovetteabejuela
Impactful Individual
Impactful Individual

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 wide date range but after the update it's now giving me that even if I select a single date to export.

 

What's going on?

1 ACCEPTED SOLUTION

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



Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany

View solution in original post

30 REPLIES 30
darkocernik
New Member

I'm running the Version: 2.56.5023.942 (March)  and still have the same issue. Also, it seems a maximal number of rows which can be exported is 30000!

Shelley
Continued Contributor
Continued Contributor

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!

ovetteabejuela
Impactful Individual
Impactful Individual

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



Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany

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

 

K_Baathe
Frequent Visitor

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

Shelley
Continued Contributor
Continued Contributor

@LY18 Once the report is published to powerbi.com, hover over the visual you want to export and three dots should appear in the upper right corner. You can then select Export and continue exporting to Excel file format.

 

Capture.PNG

Hi @Shelley , what version of the Power bi report.pbix file is ? because I am using october 2017 version of .pbix file and the report server is Jan 2019, still I am not able to find the mentioned option in the published report.

 

> Please provide a screen shot next to selecting the eclipse to export the file 

 

Thanks, 

Prabhu

Shelley
Continued Contributor
Continued Contributor

@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.

Annotation 2019-11-13 074142.png

@Shelley  Hoorray... it works.. Thanks a lot.. 

Shelley
Continued Contributor
Continued Contributor

You're welcome @Prabhu_MDU - Glad I was able to assist!

thanks for both feedbacks 😉

@LY18 , you can't access Excel option from Power BI dev app. You can see it only from the published report. So save, publish, go to report url, then the export pop up will ask which format.

@TomMartens,

 

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!

alex139
Frequent Visitor

You can't, unless you count the rows in your visual. As a workaround, I suggest using the October version until this gets fixed permanently,

v-yuezhe-msft
Microsoft
Microsoft

@ovetteabejuela,

The fix of this issue will be released on January.

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
June 2022 update 768X460.jpg

Check it out!

Click here to read more about the June 2022 updates!

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Power BI Dev Camp Session 23 768x460.jpg

Check it Out!

Mark your calendars and join us on Thursday, June 30 at 11a PDT for a great session with Ted Pattison!

June 20 episode 7 with aka link 768x460.jpg

The Power BI Community Show

Join us on June 20 at 11 am PDT when Kim Manis shares the latest on Azure Synapse analytics, the Microsoft Intelligent Data Platform, and notable Power BI Updates from Microsoft Build 2022.

Top Solution Authors
Top Kudoed Authors