Forum Discussion

afedianine's avatar
afedianine
Icon for Advocate II rankAdvocate II
8 years ago

Issue 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 sel...
Dashboards
v-qiuyu-msft's avatar
v-qiuyu-msft
Icon for Community Support rankCommunity Support
8 years ago

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

afedianine's avatar
afedianine
Icon for Advocate II rankAdvocate II
8 years ago

Yes, 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!