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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
pgd
Frequent Visitor

Ran Out of Memory Error

Hello, 

 

I have a Power BI dashboard (desktop) that is connected to a SharePoint list and a few Excel files. 

 

It is failing to refresh the SharePoint list. It loads 2.35 MB from the SharePoint list and then I get an error. The SharePoint list has 125,460 rows. When I export the SharePoint list to Excel, the file size is only 8,845 KB. 

pgd_0-1685653430470.png

Does anyone know what's going on here? I don't think I have too much data in the dashboard, I think there's a different issue. 

 

Please be very explicit in your answer, I'm new to Power BI. 

2 REPLIES 2
amitchandak
Super User
Super User

@pgd , seem like it is failing because of some calculated column or table.

On desktop, you can increase Data Cache management and check

 

Load Setting.png

I changed the settings according to your screenshot above. Upon doing that, the refresh was able to load 66.4 MB from SharePoint. That is an improvement from before, but it still gave me the same error. Is there a way to tell what exactly is failing? The error it's giving me isn't very informative. 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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