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

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
Bront
Regular Visitor

Dataset not refreshing - Possible Data limit hit?

Hi all,


Hoping someone can assist with my dire problem.

 

I received an email today that my dataset didn't refresh.

I decided to look at power BI and saw the following error:

Bront_1-1679561713312.png

 

 

Nothing was changed in the last day to cause this.

As it appears that it's able to pull some lists. however it's saying it's unable to get contents from the big list.

When I looked at the list settings I see that it's exceeded 5000 rows. Is this what is causing the list to not work in my Power Queries?

 

Bront_2-1679561935632.png

 

 

Or is there anything I can do to get the list showing in my reports again?

 

1 REPLY 1
lbendlin
Super User
Super User

yeap.  Read about pagination/chunking, sharepoint api, ODATA etc.

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.

Top Kudoed Authors