Reply
pgd
Frequent Visitor
Partially syndicated - Outbound

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

Syndicated - Outbound

@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

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview.
️ November 12th-14th, 2024
 Online Event
Register Here

Syndicated - Outbound

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. 

avatar user

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)