Forum Discussion
Helper IExport 150k limitation
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
Hello sam_gift ,
check this workaround https://youtu.be/fbeMw9jtJB4?si=cqOgfMKGItUjtCy_
https://youtu.be/aQV1v6HI7go?si=u9TT3Gr_-FjcqUFG
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.
2 Replies
- Idrissshatila
Super User
Hello sam_gift ,
check this workaround https://youtu.be/fbeMw9jtJB4?si=cqOgfMKGItUjtCy_
https://youtu.be/aQV1v6HI7go?si=u9TT3Gr_-FjcqUFG
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.