How to easily send an Excel extact using a paginated report in Power BI
The goal of this blog post is to show you how to create a subscription which sends the data in an Excel attachment. To do this I will first create a paginated report off an existing dataset. Once the paginated report is created, I will then create a subscription with the Excel attachment. I could then share this paginated report…
Part 4 – Creating a Power BI dataset and report using DirectLake
In the final part of my series, I am going to be creating the Power BI DirectLake dataset and report from my tables that I had previously loaded into the lakehouse. In this series I am going to show you all the steps I did to have the successful outcome I had with my client where I created the dataset…
Part 3 – Using Microsoft Fabric Dataflow Gen2 to store the data in the Lakehouse
Following on in my series, in this blog post I am going to use the dataflow Gen2 in Microsoft Fabric to load the data into a lake house table. By doing this, it will allow me to store the data in a delta lake table. In this series I am going to show you all the steps I did to…
Part 2 – Storing the Log Analytics Queries in Azure Blob Storage (Power BI Query Usage and Performance Series)
Following on in my series, in this blog post I am going to demonstrate how to store Log Analytics Queries in Blob Storage. This allows me to be able to store the Power BI Queries externally from Log Analytics and to have an easy way to get the data into my Fabric Lake house in later steps. To do this…
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…