cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Chandrarao
Frequent Visitor

Data Export to Excel limited

A report we have currently has 12-13k rows but when exporting we receive less than 10k rows. We do not know why this is happening. But the current export limits are far greater as far as I know.

 

Someone explain the reason behind it.

1 ACCEPTED SOLUTION
v-shex-msft
Community Support
Community Support

Hi @Chandrarao,

 

Based on document, I found the size limit is 30k (free user)/150k(pro user).

 

For more detail information, you can take a look at below article:

Export data from Power BI visualizations

 

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).
•Custom visuals, and R visuals, are not currently supported.
•If there is unicode in the .csv file, the text in Excel may not display properly. Although, opening it in Notepad will work fine. Examples of unicode are currency symbols and foreign words. the workaround for this is to import the csv into Excel, instead of opening the csv directly.

 

Can you share some detail content about your issue?

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post

4 REPLIES 4
v-shex-msft
Community Support
Community Support

Hi @Chandrarao,

 

Based on document, I found the size limit is 30k (free user)/150k(pro user).

 

For more detail information, you can take a look at below article:

Export data from Power BI visualizations

 

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).
•Custom visuals, and R visuals, are not currently supported.
•If there is unicode in the .csv file, the text in Excel may not display properly. Although, opening it in Notepad will work fine. Examples of unicode are currency symbols and foreign words. the workaround for this is to import the csv into Excel, instead of opening the csv directly.

 

Can you share some detail content about your issue?

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post

Anonymous
Not applicable

I am having the same issue. I have 65,000 rows and I am a PowerBI Pro user. Why is this happening?  

cwoo
Regular Visitor

yes   i am  having the same problem  in particular the desktop  export is even worse. 

 

In fact in addition to this it does not export  any complex measures  like  calculate ( sales ; sameperiodlastyear (date))  if you had a report  that has a column of last years sales. 

 

Can anyone have a soluton to complex  measures to export to a spreadsheet ?

 

Colin 

Thanks v-shex.

 

I will try this and let you know the status.

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Kudoed Authors