Migrating AAS to Power BI Premium – Real World Example (Azure Analysis Services)
In this blog post I am going to show you how I migrated an Azure Analysis Services (AAS) database to Power BI (PBI). This was inspired by the blog post: Accelerate your migration experience from Azure Analysis Services to Power BI Premium with the automated migration tool | Microsoft Power BI I thought it would be a good idea to…
Conclusion of Migrating AAS to PPU | Part 11
This is my final post and conclusion in my blog series to look at migrating from AAS to PPU. I have really enjoyed the series and I have learnt a lot along the way, I hope you enjoyed following along! Conclusion Below is my outcome for each blog series, you can also click on the link if you want to…
Costs – Part 10 | Migrating from AAS to PPU
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…
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…
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…
Changing the User Account in Excel when connecting to Power BI Premium/Per User or Azure Analysis Services
Recently I have been working where I have multiple accounts, and I wanted to test the different access to the accounts when connecting via Excel. I could not find any blog posts or videos on how to do this. In my blog post I detail how to achieve this. Connecting to the dataset using Excel The method below will work…
AAS Processing Error “Error returned: ‘M Engine error: ‘Microsoft.Data.Mashup; Token Comma expected”
I was recently working on an Azure Analysis Service – AAS project (It could also be a SQL Server Analysis Services – SSAS project), where I edited the M code using the wonderful Tabular Editor I hope that this will assist people who have a similar error and quickly find the solution to the problem! When I then tried to…