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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
MMMMigra
Frequent Visitor

Export underlying data

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.

3 REPLIES 3
v-shex-msft
Community Support
Community Support

HI @MMMMigra,

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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

Hi @v-shex-msft ,

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 @MMMMigra,

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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

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

Top Solution Authors