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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Regular Visitor

Power BI premium performance with SSAS live-connection


Background: We currently have per user pro-license model within our organization and Power BI content in our organization is created/shared with live connection to on-premise SSAS tabular & multidimensional cubes.


Problem: Some of the Power BI content on large cubes seem to be having performance problems, with large content and complex calculations. The performance sometimes is intermittent, sometimes content renders in <5 seconds and sometimes it turns really sluggish. This could be perhaps due to shared capacity  



With Power BI Premium, I understand Capacity is provisioned through purchasing capacity nodes. Each node is composed of a number of v-cores: frontend cores and backend cores.


The frontend cores are responsible for the web service, dashboard and report document management, access rights management, scheduling, APIs, uploads and downloads, and generally for everything that relates to the user experience. The backend cores are responsible for the heavy lifting: query processing, cache management, running R servers, data refresh, natural language processing, real-time feeds, and server-side rendering of reports and images. The backend cores that do the heavy lifting are fully dedicated to you, and they will not be shared by others. The frontend cores are shared with others, and they are computed as your portion.


We would like to assess performance of our Power BI content hosting on dedicated capacity with Power BI premium however I am wondering if this would make any difference as frontend cores are shared anyway and what we could benefit from with dedicated backend cores as we connect live to on-premise cubes.


Would be great to hear your thoughts around this? Any experiences if anyone made similar assessment?


Thank you.




Community Support
Community Support

HI @HUSS340824,


I'd like to suggest you to take a look at following link to know power bi premium capacity management and optimization:

Power BI Premium capacity resource management and optimization


It should increase refresh and loading performance when you upgrade your license to premium, but it is hard to say accurate performance increase percentage.


BTW, when power bi not refresh your datasets , it will spend some resource to calculate your formulas and update visual graph, so it will affect loading performance.


After finished refresh operation, it will load cache data to power bi service to reduce cost of loading time.

Data refresh in Power BI



Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

Helpful resources

Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City


Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors