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.
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
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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
15 | |
7 | |
5 | |
3 | |
3 |