Issue with "Export to Excel"

[afedianine]

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!

[v-qiuyu-msft]

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]

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!

[lndnbrg]

Did you try to connect to your data through „Analyze in Excel“? I haven’t tried, but can you get more rows there?

[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