Premium Capacity Memory Issue

[dmbd1904]

Hello,

I have built a Power BI report for a client. It refreshed perfectly in their environemnt under a PPU Trial License. After proving the concept, the solution was moved to a Premium Capacity workspace (I believe under P1 Capacity). However the dataset no longer refreshes.

Why would it work in the PPU Workspace but not the Premium Capacity workspace?

Do the memory restrictions shown in the screenshot below look normal for a P1 Capacity? And is such memory usage out of the ordinary?

[Anonymous · Accepted solution]

Hi @dmbd1904 ,

Typically, the effective memory limit for a command is calculated on the memory allowed for the dataset by the capacity (25 GB, 50 GB, 100 GB) and how much memory the dataset is already consuming when the command starts executing. For example, a dataset using 12 GB on a P1 capacity allows an effective memory limit for a new command of 13 GB. However, the effective memory limit can be further constrained by the DbPropMsmdRequestMemoryLimit XMLA property when optionally specified by an application. Using the previous example, if 10 GB is specified in the DbPropMsmdRequestMemoryLimit property, then the command’s effective limit is further reduced to 10 GB.

If the command operation attempts to consume more memory than allowed by the limit, the operation can fail, and an error is returned. For example, the following error describes an effective memory limit of 25 GB (P1 capacity) has been exceeded because the dataset already consumed 12 GB (12288 MB) when the command started execution, and an effective limit of 13 GB (13312 MB) was applied for the command operation:

"Resource governing: This operation was canceled because there wasn’t enough memory to finish running it. Either increase the memory of the Premium capacity where this dataset is hosted or reduce the memory footprint of your dataset by doing things like limiting the amount of imported data. More details: consumed memory 13312 MB, memory limit 13312 MB, database size before command execution 12288 MB. Learn more: https://go.microsoft.com/fwlink/?linkid=2159753."

More details : Troubleshoot XMLA endpoint connectivity in Power BI - Power BI | Microsoft Learn

Best Regards

Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.