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: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

zombi3

PowerBI only able to load 200 rows from sharepoint list

Submitted by on ‎02-06-2025 05:04 AM

Hi Support,

 

I am hoping someone could help me, I'm trying to create a powerBI dashboard by linking live data in sharepoint online list which contains more than 8000 rows. However, only 200 rows were loaded and I am not sure what is the error here.

Status: Investigating

Hi  @zombi3 ,

 

The SharePoint Online connector has a hard limit on the number of rows it will look through for any single query. If it does not find any matching rows in the first set, it will return a link to another query that you must perform yourself.

 

Best Regards,
Community Support Team _ Caitlyn

 

See more ideas labeled with:
1 Comment (1 New)
Comments
v-xiaoyan-msft
Community Support
Community Support
‎02-06-2025 10:03 PM
Status changed to: Investigating

Hi  @zombi3 ,

 

The SharePoint Online connector has a hard limit on the number of rows it will look through for any single query. If it does not find any matching rows in the first set, it will return a link to another query that you must perform yourself.

 

Best Regards,
Community Support Team _ Caitlyn

 

Idea Statuses