Power BI has always been about making your data visible. By creating pie charts, line graphs, tables, and all other kinds of visuals, you can show organizations their performance in finance, sales, you name it. With KPI Cards you can show if they’re on track with their target, and with alerts in dashboards, you can notify anyone and show when somethings wrong. With the new Goals feature in Power BI you can also track its history!

At the Microsoft Business Application Summit (MBAS) on the 4th of May, Microsoft announced “Power BI Goals” as a new premium feature in the…

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.

Relative Date or Between date?

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

Microsoft Forms can be used to get (customer) feedback, surveys, or registrations. You can ask different kind of questions:

  • Multiple choice (including multiple answers)
  • Open Answers
  • Rating
  • Datepicker
  • Classification
  • Likert scale
  • File Upload
  • Net Promoter…

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!

The Problem

When I want to add an external user to my workspace, I get the following error:

The email address is invalid.

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.

The Solution

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 Dashboard (to create my alert)
  • Adaptive Card designer (to design my alert)
  • Power…

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:

Input values for creating a streaming dataset
Input values for creating a streaming dataset

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! …

Erik Hamoen

Enthousiastic Power BI'er

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store