Forum Discussion
afedianine
Advocate II
Advocate IIIssue with "Export to Excel"
Good morning!
I am using Power BI to build accounting dashboard. Our GL system is large, over 15ml. records for 3 years. So when I drill in account activity for a particular account, and then select "Export Data" option, Excel file always cuts off at 150001 rows of data. Is this by design? Thank you!
4 Replies
v-qiuyu-msftCommunity Support
Hi afedianine,
Yes, you can look at this article:
- The maximum number of rows that can be exported to .xlsx when in the Power BI service is 150,000 for Pro users and 30,000 for Free users.
Best Regards,
Qiuyun Yu
afedianineYes, I understand that. I would suggest removing the pro limit, since native excel can support 1m rows and Power Pivot can support unlimited rows. For working with GL data for a large company 150k rows is extrimely limiting.
Thank you!
- v-qiuyu-msft
Hi afedianine,
For your requirement, you can submit a idea: https://ideas.powerbi.com/forums/265200-power-bi-ideas
Best Regards,
Qiuyun Yu