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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
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

 

1 REPLY 1
mgmeyer
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

Announcements
Fabcon_Europe_Social_Bogo

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.