Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowJuly 7 - July 17 | Round 2 of the Power BI Dataviz World Championships. Don't miss your chance! Learn more
Hi expert,
Power BI limitation is 30,000 rows for CSV and 150,000 for .xlsx as you may already know.
How can i export underlying data more than 300,000 rows?When exporting the underlying data, I need to carry the interaction parameters (slicer, filter, etc.) in the current report.
HI @Anonymous,
AFAIK, it should be the limitations of power bi export feature and current not exist similar feature to export large amount of records.
Have you worked with the premium license? If that is the case, you can try to use XMLA endpoint features to connect to the data model. (in this mode, you can do some advanced operations on these underly data)
Dataset connectivity and management with the XMLA endpoint in Power BI - Power BI | Microsoft Docs
Regards,
Xiaoxin Sheng
Hi @Anonymous ,
Thanks, but I can not find the soultion. Could you Please describe the answer in detail?After my research, I'm afraid I can't export more than the limit in PBI?
HI @Anonymous,
You can use the XMLA endpoint feature to connect to the dataset directly, then you can try to export data from this model. It is not used to default export feature so it may not trigger the limit of export amount.
How to Export Data from Power BI using XMLA Endpoints - sqlitybi
Regards,
Xiaoxin Sheng
Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.
Join Fabric Data Days 2026: 60 days of free live/on-demand sessions, challenges, study groups, and certification opportunities.