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…
Power BI – Which tables and columns are being used the most in Power BI Premium/Premium Per User
I was reading through the blog post Announcing on-demand loading capabilities for large models in Power BI and I got a thought would it not be great to better understand which columns and tables are being used in my Power BI Premium/Premium per user datasets? To do this, using the new DMV I could now look at the temperature of…
How to use the Power BI Embedded Playground
One of the great things about Power BI is how they make things a lot easier and better to use. I have been answering some questions in the Power BI Community and other people have been looking into using Power BI Embedded. This led me to find out that there is a quick and easy way to test out Power…
Using the Power BI Async REST API to refresh a partition with Power Automate (Using an HTTPS URL)
Welcome to 2022, I am looking forward to an awesome year ahead! With the new awesome feature of now being able to use the Asynchronous refreshing with Power BI Premium/Premium per user I wanted to see if it was possible to use Power Automate to automate the process (Obviously). My goal was to be able to refresh an individual partition…
How did I keep my Power BI dataset measures documented and up to date?
One thing that often happens is when users are using a dataset, they want to know which measures are available. And not only that sometimes they want to know the measure definition. This got me thinking and how best could I give this to the users in my organization to be able to find this information quickly and easily. In…
Creating Power BI Premium Per User or Premium Partitions with Tabular Editor
What I find I wanted to do with a new PPU Dataset with incremental partitions is I did not want to wait for the PBI Service to complete this. The reason is that very often there are issues, and it takes a long time to complete. I wanted to have the control where I can process the partitions as I…