Category: Power BI Premium

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…

Power BI – Which tables and columns are being used the most in Power BI Premium/Premium Per User

I was reading through the blog post Announcing on-demand loading capabilities for large models in Power BI and I got a thought would it not be great to better understand which columns and tables are being used in my Power BI Premium/Premium per user datasets? To do this, using the new DMV I could now look at the temperature of…

Using the Power BI Async REST API to refresh a partition with Power Automate (Using an HTTPS URL)

Welcome to 2022, I am looking forward to an awesome year ahead! With the new awesome feature of now being able to use the Asynchronous refreshing with Power BI Premium/Premium per user I wanted to see if it was possible to use Power Automate to automate the process (Obviously). My goal was to be able to refresh an individual partition…

Power BI Premium/Premium Per User – Automating Processing of historical partitions

I recently had a big challenge with one of my customers where due to the sheer volume of data and network connectivity speed I was hitting the 5-hour limit for processing of data into my premium per user dataset. My solution was to change the partitions from monthly to daily. And then once I have all the daily partitions merge…

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…

Calculation Groups with Disconnected Tables in Power BI/AAS

Below I will explain how to use Calculation Groups with Disconnected tables. I know that some of this might be able to be done with other calculation groups. I find I have more flexibility when combining Calculation Groups with a disconnected table. Below are some of my previous calculation group blog posts that might also be of interest: Create Currency…