Power BI Query Usage and Performance Series – Part 1 – Enabling Log Analytics, generating the KQL queries
As with most of my blog posts it involves a client from a customer where I am consulting, which I think will help others. The requirement was to analyse the Power BI Query usage patterns of the users. The initial requirement was to find out how many users were using Excel to gain access to the Power BI Dataset. I…
How to refresh an Excel file stored in SharePoint Online without the need for a Power BI Gateway
I have been answering some questions on the Power BI (Or is it now Fabric?) community forum, and I have found recently that there are some people asking how to get data from Excel that is stored in SharePoint Online. In this blog post I will show you how to connect to a single Excel file using Power BI desktop,…
Did you know you can use between when creating a New Group in Power BI
I was once again working with the grouping feature in Power BI Desktop. This time I had a lot of values that I wanted to put into multiple groups. I also did not want to select the individual values (I have previously shown this in my blog post Creating a group with all values (Even if not in the data)…
Power BI – Testing Row Level Security (RLS) for multiple users in Excel
I have been doing a fair amount of work on Row Level Security (RLS) where the requirements were quite complex to implement. Once I had completed the implementation of RLS there were two outstanding items I needed to test. Make sure that the users are only viewing the data they should see. Ensure that the performance of a selected user…
How to view the Format pane in Power BI when using the new On-Object Interaction
I have enabled the new On-Object Interaction for the formatting pane in Power BI and while it is constantly improving there are times when I would like to have the good old formatting pane available. I have also found that sometimes when you create a new visual there is no option to format it as shown below. To view the…
How to create an Excel table from a DAX (Power BI) query to be used for Data Validation
I had a requirement where the customer wanted to make sure that the right user could only see the colour from the stock item assigned to them. Essentially using the Excel file for Row Level Security. For the Row level security to work correctly it required the colour name to be an exact match. For me to ensure that this…
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…