How to restore large Power BI Premium Backup files
When using Power BI Premium or Premium Per user you get the option to backup the database, there can be occasions when you try and restore the backup and it fails. The reason that it could fail is because when a restore happens it can consume additional memory which would take you up and over the memory limit. Below I…
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…
Steps on how I backed up my Power BI Premium Per User / Premium Database
Continuing with my series of using Power BI Premium Per User (PPU), today I am going to show you how to back up your PPU database. As far as I am aware all the options below will work for Power BI Premium as well. To me this is critical when my dataset size grows. Especially when it takes multiple days…
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…
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 enable dataset sizes larger than 10GB for Power BI Premium or Power BI Premium Per User
By default, when using Power BI Premium or Power BI Premium per user the dataset size is set to 10GB. I have had the wonderful experience of refreshing my dataset and getting the following error: In the steps below I will show you how to change this setting to allow for larger dataset sizes. Finding the dataset GUID The first…
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…