Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
sam_gift
Helper I
Helper I

Export 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

2 ACCEPTED SOLUTIONS
Idrissshatila
Super User
Super User

Hello @sam_gift ,

 

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

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

 



Did I answer your question? Mark my post as a solution! Appreciate your Kudos
Follow me on LinkedIn linkedIn
Vote for my Community Mobile App Idea

Proud to be a Super User!




View solution in original post

v-nuoc-msft
Community Support
Community Support

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.

View solution in original post

2 REPLIES 2
v-nuoc-msft
Community Support
Community Support

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
Super User
Super User

Hello @sam_gift ,

 

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

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

 



Did I answer your question? Mark my post as a solution! Appreciate your Kudos
Follow me on LinkedIn linkedIn
Vote for my Community Mobile App Idea

Proud to be a Super User!




Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors