Azure analyiss server vs powerbi? key difference, when to consider AAS?

a1990 16 Reputation points
2022-05-22T19:33:00.537+00:00

Understood powerbi has similar features of AAS, can you anybody tell us in which situation need to consider the Azure analysis service ? Our business want's semantic business data model with self severing capability. i am aware it supported under AAS, does poewrbi has same feature and their powerbi datamodel can be shared in different reporting?
i am hearing from my colleague AAS service going to deprecated shortly and taken over by power bi, is it true? i can't find any article AAS service deprecation and where i can find microsoft link on AAS roadmap including end of support date?
Please advise key difference?

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
480 questions
SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,344 questions
{count} votes

2 answers

Sort by: Most helpful
  1. Nandan Hegde 36,156 Reputation points MVP Volunteer Moderator
    2022-05-23T04:41:18.297+00:00

    Hey,
    The below 2 blogs should explain in detail w.r.t AAS and PowerBi and when to make the choice :

    blog.coeo.com/power-bi-premium-vs-azure-analysis-services

    https://www.sqlbi.com/blog/marco/2021/06/29/choosing-azure-analysis-services-or-power-bi-premium-for-large-datasets/

    0 comments No comments

  2. ZoeHui-MSFT 41,496 Reputation points
    2022-05-24T01:16:49.517+00:00

    Hi @a1990 ,

    You may also refer to below Power BI official blog regarding this:

    There are two key takeaways from this blog. First, there are a few capabilities where Azure Analysis Services satisfies requirements not yet generally available (GA) in Power BI Premium. If you require very large datasets or query scale out today, Azure Analysis Services might be your preferred solution. However, these features will soon be matched or exceeded in Power BI Premium.

    Second, Power BI Premium is the enterprise platform for modern enterprise cloud BI applications. Analysis Services is the engine powering this platform. While Power BI Premium has (and will continue to have) additional capabilities for performance, scale, and management, the engine itself may satisfy your needs. Both are excellent and the choice between the two options is dependent on your business requirements.

    https://powerbi.microsoft.com/en-us/blog/power-bi-premium-and-azure-analysis-services/

    Regards,

    Zoe


    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.