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: 

Get inspired! Check out the entries from the Power BI DataViz World Championships preliminary rounds and give kudos to your favorites. View the vizzies.

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