cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
aldredd
Advocate I
Advocate I

Export data to excel - Pro Limit not being honoured

Hi, I'm trying to export some data from Desktop.

 

I know there is normally a 30k rows limit on exporting, but according to this article if I'm signed into my Pro account (which I am) I should be able to download 150k rows

 

Limitations and considerations

  • The maximum number of rows that can be exported is 30,000 (for Power BI Free users) and 150,000 (for Power BI Pro users).

(I'm actually on a Pro Trial account in case there's a known disparity between trial Pro & full Pro)

 

Is anyone else able to have the 150k pro limit honoured? Any other way of extracting the resulting tables? (Publishing to Web not an option for this dataset)

 

Thanks

2 ACCEPTED SOLUTIONS
v-ljerr-msft
Microsoft
Microsoft

Hi @aldredd,



Hi, I'm trying to export some data from Desktop.

 

I know there is normally a 30k rows limit on exporting, but according to this article if I'm signed into my Pro account (which I am) I should be able to download 150k rows.


As Power BI Desktop is a free desktop application you can install right on your own computer, I don't think it will work differently according to the different account type you're signed in. It seems that we can only export 30k rows on Power BI Desktop.

 

So the limitation mentioned in the article is for Power BI Service, not for Power BI Desktop. And I have verified that I can export 150k rows from Power BI service with a Pro account.Smiley Happy

 

Regards

View solution in original post

you can try this powershell script

 

https://github.com/djouallah/PowerBI_Desktop_Export_CSV

 

but if your data sets is small less than 1 Million, the easiest way is copy table past in Excel.

 

 

View solution in original post

2 REPLIES 2
v-ljerr-msft
Microsoft
Microsoft

Hi @aldredd,



Hi, I'm trying to export some data from Desktop.

 

I know there is normally a 30k rows limit on exporting, but according to this article if I'm signed into my Pro account (which I am) I should be able to download 150k rows.


As Power BI Desktop is a free desktop application you can install right on your own computer, I don't think it will work differently according to the different account type you're signed in. It seems that we can only export 30k rows on Power BI Desktop.

 

So the limitation mentioned in the article is for Power BI Service, not for Power BI Desktop. And I have verified that I can export 150k rows from Power BI service with a Pro account.Smiley Happy

 

Regards

View solution in original post

you can try this powershell script

 

https://github.com/djouallah/PowerBI_Desktop_Export_CSV

 

but if your data sets is small less than 1 Million, the easiest way is copy table past in Excel.

 

 

View solution in original post

Helpful resources

Announcements
Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Top Solution Authors
Top Kudoed Authors