cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
odoardil Regular Visitor
Regular Visitor

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

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!!

2 REPLIES 2
Pauwnrajpp Member
Member

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

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

odoardil Regular Visitor
Regular Visitor

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

Hi @Pauwnrajpp ,

 

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.