Scheduling the Power BI Premium Backup – Part 2
In this blog post I am going to detail how to create a schedule, test and confirm that the backup for the Power BI Premium dataset is successfully backed up. This follows on from my first blog post: Automating the backup of Power BI Premium datasets/databases – Part 1 Getting the Power BI XMLA URL and Dataset name Before creating…
Automating the backup of Power BI Premium datasets/databases – Part 1
Use the script from Azure Runbook Can use this as reference: Steps on how I backed up my Power BI Premium Per User / Premium Database – FourMoo | Power BI | Data Analytics The first part in this 2-part series I am going to explain how configure the Azure Runbook so that you can then re-use it for multiple…
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…
Checking your Power BI Pro or Power BI Premium Per User licenses could save you money!
I recently was assisting a customer with their Power BI licensing and what I found is that in some instances they were having licenses for Power BI Pro and Power BI Premium Per User. By going through their licenses and assigning the correct license I was able to save the customer approximately 20% on their Power BI licensing costs per…
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 did I keep my Power BI dataset measures documented and up to date?
One thing that often happens is when users are using a dataset, they want to know which measures are available. And not only that sometimes they want to know the measure definition. This got me thinking and how best could I give this to the users in my organization to be able to find this information quickly and easily. In…
Creating Power BI Premium Per User or Premium Partitions with Tabular Editor
What I find I wanted to do with a new PPU Dataset with incremental partitions is I did not want to wait for the PBI Service to complete this. The reason is that very often there are issues, and it takes a long time to complete. I wanted to have the control where I can process the partitions as I…