Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.

Reply
Anonymous
Not applicable

Power bi data export to excel

Hi ,
Please do let me know how to export data into excel for more than 150,000 rows. I have read article which mentioned the  limit of 150000 rows, if we upgrade to premium service, can we dowload more. Please do help me with this.
Thank you
Arjun

1 ACCEPTED SOLUTION
Anonymous
Not applicable

HI @Anonymous,

AFAIK, the export feature has limitations on export data amount and upgrade licenses did not increase the export amounts.

If you have premium licenses, you can try to use the XMLA endpoint feature to directly connect the dataset and use it to export data. I think it can export more data than default export features.

Dataset connectivity and management with the XMLA endpoint in Power BI - Power BI | Microsoft Docs

How to Export Data from Power BI using XMLA Endpoints - sqlitybi

Regards,

Xiaoxin Sheng

View solution in original post

2 REPLIES 2
Anonymous
Not applicable

HI @Anonymous,

AFAIK, the export feature has limitations on export data amount and upgrade licenses did not increase the export amounts.

If you have premium licenses, you can try to use the XMLA endpoint feature to directly connect the dataset and use it to export data. I think it can export more data than default export features.

Dataset connectivity and management with the XMLA endpoint in Power BI - Power BI | Microsoft Docs

How to Export Data from Power BI using XMLA Endpoints - sqlitybi

Regards,

Xiaoxin Sheng

HenriqueReis
Resolver I
Resolver I

Hi,

 

The documentation states that there is a limit of rows that can be exportet to csv, this limit is 30000 rows.

 

Using the target format xlsx this limit is 150k rows, the export to xlsx option is available in Power BI Service.

 

These limits are described here:

https://docs.microsoft.com/en-us/power-bi/power-bi-visualization-export-data

 

Theres no way to do it (upload more then 150k of rows) in Power BI Premium too, look:

https://www.pbiusergroup.com/communities/community-home/digestviewer/viewthread?MessageKey=0f9067ab-...

 

Hope I solve your doubt!

 

Regards from BR!

Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors