Power BI Gateway – How to allow multiple users to use the same data source for their dataset
Recently I got a question on the Power BI Community forum which was “Is it possible to allow multiple users to use the same data source for their report”? I thought it would be a great blog post so that other users could also benefit from this knowledge, as once you know it is quite a simple process to complete…
Troubleshooting Power BI PowerShell issues to view the error
I have been recently using the Power BI PowerShell modules to get some information from the Power BI APIs to store the data. I ran into an issue where something was not working and I found a great cmdlet which allowed me to view the Power BI errors that I had been querying via PowerShell. NOTE: To use the PowerShell…
Refreshing a Power BI Dataset using an HTTPS URL
I have found that sometimes there are other systems that are loading data, and once they are complete they then want to refresh the Power BI Dataset. Another way to do this is to use Power Automate, in which a system or user can request a HTTPS URL and once called that will then refresh the Power BI dataset. I…
Different Power BI Export to table options and what they look like
I was recently helping out a customer and they contacted me asking why was the export option not in the format that they expected. I had a look and now because there are so many options to export data, each one exports the data differently. My goal for this blog post is to show you what each export type looks…
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…
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…