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
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

July Newsletter

Fabric Community Update - July 2024

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