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…
Incredible Power BI Announcements at Microsoft Business Applications Summit 2021
As I have done each and every year I go through and give an overview of all the Power BI Announcements at the Microsoft Business Applications Summit 2021. This year once again they have announced some incredible features either available now or coming soon so, please read below. Here are the links to the videos which have got more details…
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…
How to update or create a measure to Power BI Premium Per user without having to publish entire dataset
Following on from my previous blog post How to complete granular deployment of Power BI Desktop changes to the Power BI Service (Using PPU), I want to also show how to update or create a measure in my dataset, where I can deploy this via ALM Toolkit. This now saves me from doing the following tasks previously: Time taken to…
How to complete granular deployment of Power BI Desktop changes to the Power BI Service (Using PPU)
Now that we have got Power BI Premium per User (PPU), this opens a whole host of new capabilities. In this blog post I am going to demonstrate how to make a granular deployment where I will create a new column in my City table, and only deploy those changes. What this means is that by deploying only the column…
How I changed the partition configuration (Year, Month, Quarter, Days) for my data in Power BI Premium / Power BI Premium Per user!
I have to say that I am quite fortunate to be a Microsoft MVP, and I am very grateful for the opportunity. This was one of those times when I was reading an email from Christian Wade and Christian had given me a little piece of gold. What is that gold you might wonder, well it is that there is…
How to use SSIS with Power Query to extract data from Power BI Premium and insert into local CSV
I was helping and answering some questions on the Power BI community forums and I came across a question where someone was looking to query data from Power BI Premium using SSIS (SQL Server Integration Services). This is definitely possible and I will show you below how I can use SSIS, to query data from Power BI Premium and store…
Intro into Power BI Premium
I was chatting to my good friend Treb Gatte and one of the things we both discovered is that there was not a good blog post with regards to an introduction into Power BI Premium. I thought this was a great idea and have turned it into this blog post below. I am going to cover the following sections below…
Power BI Premium Performance – Part 5 | How much memory will the PBIX consume?
This was something that I thought I had covered off already and was one of the key messages that I wanted to get across when looking to move to Power BI Premium. It can be quite confusing when always thinking about the size of a PBIX file being smaller than 1 GB and then moving to Power BI Premium where…