Export underlying data

[MMMMigra]

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.

[v-shex-msft]

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

[MMMMigra]

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? 

[v-shex-msft]

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