When I started as a BI consultant, the only way to create page navigation in Power BI was by using bookmarks and my other main use for bookmarks was creating a “Clear filters” button, to reset all my slicers in a report. In this article, I’ll show some extra usage for buttons and bookmarks.
One of my customers asked me: Erik, we want to select the last seven days, or thirteen weeks, or six months. But, we also want to be able to select a start and end date. The solution was easier than expected, using bookmarks and synching slicers.
I once had a customer who had a large collection of data from different subsidiaries. These companies were only allowed to see their own, anonymized data, but the Security Officer of the main company also needed to see the Personal Information (PI) of all employees.
Eventually we “solved” this by creating two reports, which also means two reports to maintain. The February release of Power BI finally has a solution: Object Level Security (OLS).
In combination with Tabular Editor you can now control access to certain columns or even entire tables for certain roles. …
Showing Microsoft Forms results in Power BI
A few days ago, someone asked me to think of a solution to show the responses of a Microsoft Form in Power BI. During this project, I used Forms, Power Automate, Excel, OneDrive, and of course Power BI. I found some interesting obstacles that I want to show you, but first, I start creating a form!
Microsoft Forms can be used to get (customer) feedback, surveys, or registrations. You can ask different kind of questions:
A few weeks ago one of my colleagues showed me a PowerShell script to export all Power BI reports from a Power BI Workspace. This could come in handy for back-up purposes (version control is still hard to accomplish) or if you don’t have access to the PBIX files via the normal way and you need to do some edits. The original file can be found here.
I made some changes to the original file to download all reports, from all workspaces and put them in a nice folder structure, with the same names as your workspaces. Of course, it’s…
A question I often get is how companies can share Power BI reports with external users, and how they can participate in a workspace. In this story, I’ll show you!
When I want to add an external user to my workspace, I get the following error:
I’m very sure that I haven't added the user already, and I’m also sure that the email address is correct! The problem is that you can only let people from your tenant access the workspace! You can create guest user accounts in Azure Active Directory, but there is also a simpler, more automated way.
In my previous post, I explained how you could create variable thresholds in Power BI for your alerts. In this post, I will explain how you could notify your whole team that something is wrong. For example, if you are working with a data warehouse and want to inform your team that the latest data load has failed, so the current data isn’t up-to-date.
In this post, I will continue with my CPU alert, and I will use the following software to inform my team:
Power BI Alerts are an interesting way to notify you when something is wrong. In this article, I will show you how to set up alerts with a variable threshold. For this example, I use a streaming dataset, created in Power BI, and a PowerShell script I got from the guys at Guy in a Cube.
So first we create a streaming dataset in Power BI:
Don’t forget to turn on historic data analysis as mentioned in the video, otherwise, you can’t create a report! The values are standard so don’t worry about that now! …
Enthousiastic Power BI'er