Export data to Excel

[vikkidurai91]

Hello

We are trying to export data to excel in Service, but we see limitation for .xlsx is 150000 records. 

Is there any chance that Microsoft will extend this limit in near time? If someone has faced this issue, please suggest.

Thanks

Vignesh

[v-yingjl]

Hi @vikkidurai91 ,

If you've fixed the issue on your own please kindly share your solution. If the above posts help, please kindly mark it as a solution to help others find it more quickly. Thanks!

Best Regards,
Yingjie Li

[Alimantado]

I am new to PBI and must learn it coz of work.  Intriguing how Microsoft is lucky, they can create unfriendly apps with bad usability and still many companies use it.  Bluntly we cannot export to Excel.

[v-yingjl]

Hi @vikkidurai91 ,

You can pay attention to this article which lists features that are planned to release from April 2020 through September 2020.

Also, you can submit the requirement to ideas and add your comments there to vote for it to help us improve power bi and make this feature coming sooner: https://ideas.powerbi.com/forums/265200-power-bi-ideas

Best Regards,
Yingjie Li

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[ibarrau · Accepted solution]

Hi. I'll ask some community partners if there are plans for this and edit the post. In midtime you can try connecting the model with excel to build something you want there or export in power bi refresh process. Links on how to do this two this next:

https://blog.ladataweb.com.ar/post/187512469605/conectar-excel-a-power-bi

https://blog.ladataweb.com.ar/post/617917545084846080/powerbi-exportar-datos-automáticamente-al

EDIT: I have an answer of microsoft team and was "Don't wait for a change in the 150k export row limitation". Try other alternatives.

Hope this helps,

Regards,