Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Hi @afedianine,
Yes, you can look at this article:
Best Regards,
Qiuyun Yu
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!
Hi @afedianine,
For your requirement, you can submit a idea: https://ideas.powerbi.com/forums/265200-power-bi-ideas
Best Regards,
Qiuyun Yu
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.