Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Not applicable

Performance differences - measures on SSAS vs measures on Powerbi

Hi there,


We started publishing powerbi reports on prem through Live Connection SSAS 2012.


I wonder if anyone can feedback in terms of measures. I see the benefit of creating measures on PowerBI because sometimes I need to do things on the fly...however I dont know if this makes the whole report running slower than using measures creating in SSAS....?


Hope you understand what I try to get at... basically are there any performance issues / differences between using rendering measures that are creating on SSAS and those created directly on Powerbi?


Many thanks


Power BI Team
Power BI Team

For specifics on measure performance between different versions of Analysis Services (including the one used within Power BI) you should probably try the AS forums here. What I can tell you is there is likely a big difference between 2012 and Power BI AS. Depending on which version of SSAS 2012 you have the compat level supported by that server is either 1100 or 1103. Power BI is closely aligned with Azure Analysis Services/SQL AS 2017 which has a compat level of 1400. Even with the compat levels aside there have been a number of engine and DAX performance improvements over that last few releases of SQL AS. You can check this link which is a summary of all the "What's new" posts that the AS team has published on there blog, you can take a look at all of the enhancements since 2012. Hope this helps, thanks!

Helpful resources

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.