One of the most important aspects when looking to migrate from AAS to PPU is what will costs be. This plays an important part in the decision.

In this blog post instead of doing an AAS and PPU comparison I am going to do this side by side, which I feel will make it easier to compare.

In my opinion it is only fair to compare the same sizing between AAS and PPU, and this can only be done by using the Memory allocation.

For this comparison I am going to compare the following:

  • Memory – 100GB

Here are the previous 9 blog posts that I have completed in the series.

1 – Query Performance – Part 1 Migrating Azure Analysis Services to Power BI Premium Per User – Reporting/Analytics Made easy with FourMoo and Power BI

2 – Scalability – Part 2 Migrating AAS to PPU – Reporting/Analytics Made easy with FourMoo and Power BI

3 – Data Loading – Part 3 | Migrating AAS to PPU – Reporting/Analytics Made easy with FourMoo and Power BI

4- Incremental Refreshing – Part 4 – Migrating AAS to PPU – Reporting/Analytics Made easy with FourMoo and Power BI

5- Historical Data Loading – Part 5 – Migrating AAS to PPU – Reporting/Analytics Made easy with FourMoo and Power BI

6- Logging (Datasets, users & query performance) – Part 6 – Migration AAS to PPU – Reporting/Analytics Made easy with FourMoo and Power BI

7-Modelling – Part 7 | Migration from AAS to PPU – Reporting/Analytics Made easy with FourMoo and Power BI

8- Deployments – Part 8 Migrating from AAS to PPU – Reporting/Analytics Made easy with FourMoo and Power BI

9- Row Level Security – Part 9 | Migrating AAS to PPU – Reporting/Analytics Made easy with FourMoo and Power BI

Comparison

When I started with this comparison it starts to get a little more complicated.

The reason is that for AAS it has a fixed monthly cost no matter how many users use AAS.

I compare this to PPU, where it has a fixed monthly cost PER USER.

Looking into this how can I compare APPLES WITH APPLES because the costs are different!

Here is the comparison as is below

What I did here is to get the monthly cost for an AAS S4 instance

To give a fair comparison, I do feel that it would be best to compare when there are at least 100 users.

As shown above the cost for PPU is significantly cheaper than AAS.

There are a whole host of other considerations to think about when looking to get an accurate comparison which would potentially be the following:

  • How many users are going to be accessing the cube/dataset?
  • Are the queries intensive or consume a lot of memory?
  • What if you need more than 100 GB of Memory (which can happen, but very often the dataset can be optimized)?
  • Features available in PPU which are not currently available in AAS

Summary

In this blog post I have shown what the costs are between AAS and PPU and tried to compare them in a way that makes sense for your situation.

Once again it appears to me that based on the costs it would certainly be feasible to migrate from AAS to PPU.

Thanks for reading and comments or suggestions are most welcome.

As with the current series I once again do think in my opinion that it is extremely attractive to move to PPU.

Any questions or comments are always welcome in the section below.

Thanks for reading!