Did you know that there is an easy way to shape your data in Fabric Notebooks using Data Wrangler?
I was going through my twitter feed and I came across this tweet where they spoke about the Data Wrangler Calling all #Python users! Have you tried Data Wrangler in #MicrosoftFabric? I thought I would give this a try and that was the idea for my blog post. I honestly had no idea that firstly was this possible, but second…
Creating a Hierarchy for Field Parameters for easier navigation
I was working with a customer where they had a lot of measures which they wanted to use with the awesome Field parameters for measures. The challenge was that there was a LOT of measures, and I wanted to see if there was a way to create a hierarchy in my field parameters so that it would be easier to…
Using Power BI DirectLake in Microsoft Fabric
I am super excited to release this blog post and I cannot wait to start using Microsoft Fabric and all the different components. The goal of my blog post is to look at how I could use Microsoft Fabric from a Power BI developers point of view. Microsoft Fabric is a new all in one platform which includes Power BI….
How to modify Dynamic Format Strings in Power BI
I was recently testing out and using the great new Power BI feature using dynamic format strings in Power BI. What I found that currently it is not possible or easy to modify an existing dynamic format string. In this blog post below I show you how I managed to modify the dynamic format string, so that you do not…
Power Query – How to run a query only if data is returned
I had a requirement where I wanted to only have the underlying query run if there was data in the table. As shown in the image below a query would run, scan 20GB and then return zero rows. After making the changes what then happens is an initial query runs which will count the number of rows and if there…
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…