Power BI Pro, "Export data" is limited to less than 70.000 lines

[Anonymous]

Hi all,

I have a live connection to a SSAS Multidimensional and a Power BI Pro license.

If I try to export data from a matrix visual to Excel (.xlsx), I can't export more than 70.000 lines, but I know that the limit is 150.000..

Does anyone have the same problem? What could it be?

I tried with other models in import mode  in Power BI and the export data works correctly

Thank  you!!

[Anonymous]

Hi Odoardil,

Just go through the limitations of Power BI for your Information.

https://community.dynamics.com/crm/b/cognettacloud/archive/2018/01/19/cannot-export-more-than-50k-ro...

Regards,

Pradeep

[Anonymous]

Hi @Anonymous ,

Thank you for the information, I read the article but I don't see any explication about my limitation. I have a Live Query connection, not a Direct query connection, and my exported excel is not bigger than 2 MB.

I'm sorry but still can't see the solution. Can anyone reproduce the issue?

Thank you.