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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
somu117
Regular Visitor

The operation was throttled by power bi premium due to insufficient memory

Hi,

 

The Datarefresh is failing with the error 'The operation was throttled by power bi premium due to insufficient memory'.The User tried to run Adhoc refresh and it did not work.

When the User deletes the dataset and publish again its working fine.

 

Please provide your solution on how to solve the issue.

 

Regards,

Pradeep

 

 

9 REPLIES 9
DKDBA
Frequent Visitor

Can we see details on the query level?

 

yes, for whatever reason they are called artifacts:

 

  • Artifacts - A list of Power BI items active during the selected period of time. The item name is a string with the syntax: item name \ item type \ workspace name. You can expand each entry to show the various operations (such as queries and refreshes) the item performed.

DKDBA
Frequent Visitor

We are already on P3 capacity and we are able to refresh when there is no other users running queries on the dataset.  Is there any way we can see a break down of the user activity.

 

you mean beyond the individual queries?

DKDBA
Frequent Visitor

Is there any way to see memory on the activity or artifact level. We are on P3 capacity and my understanidng is that memory assignement is 100GB per model. How is it posible to reach memory capacity if model size is 30GB. Any thought on that. 

Thank you very much for your reply and the link you provided. Is it possible to add memory usage on interactive operations

 

DKDBA_0-1675460917251.png

 

you can modify the report as needed.  Not sure if they offer more memory utilization details. 

lbendlin
Super User
Super User

- upgrade your Premium SKU for example from a P1 to a P2

- enable elastic capacity

 

  (warning: both options incur additional cost)

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.