Memory limit reduced without change

[ImJeebus]

Hi all - thanks in advance for any help with this.

I've set up an incremental refresh, which seemed to be working okay (still not 100% sure if I've set it up correctly), which was semi-successful.

Some days it would refresh fine, others it would fail due to memory limit reaching 4482 MB. Now I am having an issue where the refresh is failing, this time reaching a memory limit of 2772 MB.

My IT team have told me that there have been no changes, and the settings are currently:
V-CORES = 2
MEMORY = 5 GB

Hoping someone could please shed some light on this as I'm quite confused.

Thanks,

Eddie

[lbendlin · Accepted solution]

still not 100% sure if I've set it up correctly

The only sure way to check is by looking at the partition refresh dates. If you have only one partition then it is definitely not working.  If all partitions have the same refresh date then it's not working yet, but may be working at the next refresh.

Memory is shared. You may have other datasets that are competing for the memory. Look at the eviction logs.

[ImJeebus]

Thanks very much @lbendlin for replying!

I'm relatively new to Power BI, is there a way for me to view partitions in Power Bi Service or do I need to use another software?

Would you also mind pointing me in the direction of the eviction logs (tried googling this and couldn't find much online about it)?

Thanks in advance!

Eddie

[lbendlin]

Troubleshoot incremental refresh and real-time data in Power BI - Power BI | Microsoft Learn

Solved: Premium App metrics and datasets evictions count - Microsoft Power BI Community