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…
Updating your Query syntax in Power Query to show the entire query in M
Welcome to 2023, I am looking forward to an amazing year! I have seen this come up a few times in Twitter where there is an option to put in your own TSQL Query or DAX Query and the input box is very small and often you cannot see the entire query as shown below. I will show you how…
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…
Testing Power BI REST APIs with Try it
Did you know that there is an easy way to run and extract Power BI REST API data? The good news is that you can do this directly in your web browser. You don’t have to install or configure anything! The method below works well if you want to either test the API to see what it returns. Or if…
Power Query – Appending text to end of column name
Power query can be so powerful and once again it came to my rescue. I had a requirement where I wanted to append some text to the end of each of the column names in my table. To do this I did the following below. This is what the columns looked like before the change. Next, I put in the…
Using Power Automate to schedule a refresh of a Power BI dataset at the time you want!
Below are the steps on how to use Power Automate to schedule a refresh of a Power BI dataset at the time you want it to. I have recently seen some questions in the Power BI Community with regards to refreshing Power BI datasets. I thought it would be a good idea to blog on how to use Power Automate…
Copy and paste Power BI Visuals in pages between Power BI Desktop Files
Did you know that if you want to it is quick and easy to copy and paste multiples Power BI visuals between two open Power BI Desktop files. To do this you can either press CTRL + A, then CTRL + C to select all the visuals from your source Power BI desktop file. Next to go the destination Power…
Getting the lineage from a Power BI dataset to table to data source to original query
As often happens blog posts originate from a customer requesting something I have not figured out before. In this example the requirement was to be able to determine which data sources were being used by which tables, which were then associated to one or many Power BI datsets. While I was working through this I figured out I could take…
How to use the Power BI DAX Debug Output when testing EvaluateAndLog
I have seen a few great blog posts with regards to the new DAX function EvaluateAndLog which can be used to show/debug what happens with DAX Measures. When I tried this out myself one of the challenges I had was where to download DaxDebugOutput, and then how to use it with Power BI Desktop. In this blog post I will…
Emailing Power BI Query output as a CSV Files using Power Automate
I recently had a requirement from a customer where they wanted a list of all Customers and the Primary Contact to be emailed to them every day. The reason for this to be emailed daily is to ensure that when calling the customer, they know whom to speak to. This got me thinking and I could use Power Automate to…