Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

View all the Fabric Data Days sessions on demand. View schedule

Reply
Anonymous
Not applicable

Speed up SharePoint list query

‎09-23-2020 12:30 PM

Are there any tips/tricks for speeding up a query to a SharePoint list? 

The topic comes up a lot but haven't seen any conclusive or clear answers.

I'm refreshing ~20k rows from a SP list and it takes 15-20 mins. Meanwhile I have a SQL query pulling back 10x the data in 10% of the time.

When I run Query diagnostics, seems like PowerBI is making hundreds of calls to my SP list to get all the data.

What can I do to speed up this SP query? 

Labels:
Message 1 of 3
1,782 Views
0
2 REPLIES 2
calerof
Impactful Individual
Impactful Individual

‎09-23-2020 02:59 PM

You can take a look at @MattAllington 's latest blog post to the subject here. Not very good news though.

F

 

Message 2 of 3
1,737 Views
Anonymous
Not applicable
In response to calerof

‎09-24-2020 10:37 AM

Yes bad news indeed...  I can't find any solutions that speed this up.

Message 3 of 3
1,700 Views
0

Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

Check out the November 2025 Power BI update to learn about new features.

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

View All
Top Solution Authors
View All
Top Kudoed Authors
View All