Premium per user

[talberg]

Hi
I have bought Premium version, but still have an issue with capacity limit

Подробнее: Resource Governing: This query uses more memory than the configured limit. The query — or calculations referenced by it — might be too memory-intensive to run. Either reach out to your Analysis Services server administrator to increase the per-query memory limit or optimize the query so it consumes less memory. More details: consumed memory 1024 MB, memory limit 1024 MB.

Please help, what i should do to use extended limit on my premium version?
Thank you

[Burningsuit · Accepted solution]

Hi @talberg 

You need to ensure your dataset is on a PPU workspace, Workspace, Settings, Premium..

If you need it you can there select "Large Dataset Storage Format",and on the Dataset settings, select "Large Dataset Storage Format".

see Large datasets in Power BI Premium - Power BI | Microsoft Docs

Hope this helps

Stuart

[talberg]

Hi @Burningsuit ,
Thank you for your reply.
As I can see in your link the limit extended to 100GB on Premium per user instead of 1GB on PRO or this is different things? 

[Burningsuit]

Hi @talberg 

This looks like you are using a Premium Per User workspace (PPU) not Premium Capacity.

Unlike Premium Capacity settings, PPU licenses do not have access to  memory management or CPU management, similar to how Pro licenses do not have such management. Tenant administrators can select feature settings for PPU licenses, but cannot manage specific workloads.

If you don't have a Premium Capacity licence your best option is to see if you can optimise the Dataset to use fewer resources.

See Power BI Premium Per User - Power BI | Microsoft Docs

Hope this helps

Stuart