Export 150k limitation

[sam_gift]

Hi,

I am aware that we can extract 500k rows with live connection to excel, but is there any workaround to extract more than 150k without a live connection? or any future expansion from 150k rows that anyone is aware of.

Thanks,

Sarvani

[Idrissshatila · Accepted solution]

Hello @sam_gift ,

check this workaround https://youtu.be/fbeMw9jtJB4?si=cqOgfMKGItUjtCy_

https://youtu.be/aQV1v6HI7go?si=u9TT3Gr_-FjcqUFG

[Anonymous · Accepted solution]

Hi @sam_gift 

@Idrissshatila Thank you very much for your prompt reply, and allow me to add something here.

Here's a post with a similar question to yours that mentions a free community tool called DAX Studio.

This may be helpful to you:

Solved: Exporting a large number of rows from Power BI to ... - Microsoft Fabric Community

Alternatively, you can consider paged reports, but this requires you to have Power BI Premium capacity.

With a Power BI Premium capacity, you can use the Power BI service to handle larger datasets.

You can create a model in Power BI Desktop that exceeds the 150,000 row limit and then publish it to the Power BI service, where it can utilize the larger capacity limits provided by your Premium subscription.

Regards,

Nono Chen

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

[Idrissshatila · Accepted solution]

Hello @sam_gift ,

check this workaround https://youtu.be/fbeMw9jtJB4?si=cqOgfMKGItUjtCy_

https://youtu.be/aQV1v6HI7go?si=u9TT3Gr_-FjcqUFG