Row Level Security – Part 9 | Migrating AAS to PPU
In this blog post I am going to cover how to implement Row Level Security (RSL) when using AAS and how this can be done on PPU. In my example below I am going to show creating to simple RLS roles which will limit data for the users who belong to 2 roles. Role 1 – USA This role is…
Deployments – Part 8 Migrating from AAS to PPU
Welcome to part 8, where in this blog post, I am going compare deploying datasets. For those people who are not exactly sure what deployments are, what this means is when you are using Power BI Desktop and you click on Publish, you are effectively deploying your changes to the Power BI Service (Which could also be a server in…
Modelling – Part 7 | Migration from AAS to PPU
In this blog post I am going to show the differences when creating a model/dataset when completing the same task in Azure Analysis Services (AAS) or Power BI Premium Per User (PPU) Here are the previous 6 blog posts that I have completed in the series. 1 – Query Performance – Part 1 Migrating Azure Analysis Services to Power BI…
Logging (Datasets, users & query performance) – Part 6 – Migration AAS to PPU
Another important aspect when having datasets is being able to log and monitor performance. In this blog post I am going to compare the logging between Azure Analysis Services (AAS) and Power BI Premium Per User (PPU). With the recent release of PPU having integration with Log Analytics it makes it a lot easier to compare the logging options between…
Historical Data Loading – Part 5 – Migrating AAS to PPU
In this blog post I am looking at how to load or reload historical data in AAS and PPU and compare the differences. It should already be noted that I am only going to compare tables where I have partitions created and enabled. The reason being for dimension tables it is typically quick and easy to reload the data by…
Incremental Refreshing – Part 4 – Migrating AAS to PPU
Welcome to the fourth instalment of my series on migrating AAS to PPU. In this blog post I am going to cover the differences, and pros and cons to incremental refreshing when migrating from AAS to PPU. The reason for incremental refreshing is that I do not have to reload the entire fact table every day when new data arrives….
Data Loading – Part 3 | Migrating AAS to PPU
Welcome to the third instalment of my series on migrating AAS to PPU. In this blog post I am going to cover what the difference to load data into AAS and how to load data into PPU and the associated performance. Here are the previous 2 parts I have completed in the series. 1 – Query Performance – Part 1…
Scalability – Part 2 Migrating AAS to PPU
Thanks for reading and welcome to part 2 of my series on migrating AAS (Azure Analysis Services) to PPU (Power BI Premium per User) If you missed the first part of the series here is the link here: Query Performance – Part 1 Migrating Azure Analysis Services to Power BI Premium Per User – Reporting/Analytics Made easy with FourMoo and…
Query Performance – Part 1 Migrating Azure Analysis Services to Power BI Premium Per User
Welcome to the first in my blog post series on evaluating the different aspects when looking to migrate from Azure Analysis Services (AAS) to Power BI Premium Per User (PPU). Apologies for this taking a few extra weeks to get started, life has been super busy, but as they say “Better late than never”. In this post I am going…
Migration from Azure Analysis Services to Power BI Premium Per User – Series Intro
I have been doing a lot of evaluation and investigations for organizations who currently are using Azure Analysis Services (AAS) and looking to see if they can leverage Power BI Premium Per User (PPU) In this series I am going to cover the following details below, which I completed to see if the migration was not only feasible but should…