Exporting a Power BI Visual data to a CSV File in SharePoint
In this blog post I am going to demonstrate how to use the new Power Automate Flow to extract data from a DAX measure into a SharePoint CSV file. I got this idea after reading the blog post from the Microsoft Power BI Team: Unlocking new self-service BI scenarios with ExecuteQueries support in Power Automate | Microsoft Power BI Blog…
How Power BI Field Parameters works under the hoods
There has been a lot of talk (on Twitter) with regards to the new Field Parameters in Power BI. Marco & Alberto have written a great blog post going into all the details as to how field parameters work, what the query looks and a lot more. I would highly suggest you read it here: Fields parameters in Power BI…
DAX – Getting Distinct Count on Dimension table for Offices that have had Sales
I had a challenge when I was looking to get the Distinct Count of Offices only for the Offices that had Sales. The reason for this measure is to get the % out of all Offices who had Sales. Below is how I solved this. What I did first was to create the following measure, the issue was that this…
Known Issues Power BI Report with Alerting
I was actually working on my own version of the Known Issues Power BI report, when the Power BI team released their blog post New Power BI Known Issue page | Microsoft Power BI Blog | Microsoft Power BI In the steps below I am going to show you the report I created, and then how I configured it to…
Which Power BI Reports do I have access to? – Part 3 – Creating the “Power BI Users Reports List” report
In this blog post I show the final part which is how I created the Power BI report which takes the previous 3 steps and then creates the Power BI Report. I am going to show you how I got the data in using Power Query and then created the Power BI report. The first part in the series can…
Which Power BI Reports do I have access to? – Part 2 – Using the Power BI Rest APIs for Apps and Apps Users data
This is the second part in my blog post series showing you how I created the Power BI Reports list. In this blog post I am going to show you how I used PowerShell to get all the information of the App Names, reports and users that have permissions in the different Apps. Users can get access to Power BI…
Which Power BI Reports do I have access to? – Part 1 – Using the power BI Scanner to get App Workspace data.
As mentioned in my previous blog post this is part 1 of the series where I am going to show you how to use the Power BI Scanner to get the App workspace data. I am also going to mention that the Power BI Scanner from PowerBI.Tips and Tommy Puglia (Twitter) has a wealth of other awesome information for your…
Introduction into my blog series on “Which Power BI Reports do I have access to?”
In this series of blog posts, I am going to show you how I created a solution for a client. I got the following question from a customer I was consulting to: “There are so many reports in the organization, I would like to know which Power BI Reports I have got access to in a central location” This got…
Where has the conditional formatting gone with the new Power BI Desktop formatting pane?
I am sure everyone can agree that the new formatting pane is an awesome change. But at the same time, I have found it a challenge to find settings with the new format pane. In this blog post I will show you to find the conditional formatting which appears to have gone missing in the new format pane? In my…
Did you know you can get the advanced filtering pane to show more than two items in Power BI?
Recently I found out a way to update the advanced filtering pane to show more than the default of two items. This is what it looks like by default. What I figured out was to then have an extra 4 options to filter on. The reason that this came about is because I was using at integer field which does…