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:

Image for post
Image for post
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