Open in app

Sign In

Write

Sign In

Erik Hamoen
Erik Hamoen

38 Followers

Home

About

Jan 4

Analyzing Teams data over a full year

Since 2021 you can analyze your Teams data in a generated Power BI report from Microsoft. It shows you the data from the last 90 days by default, but you can edit the report and add incremental refresh to keep track of all Teams data for a more extended period…

Power Bi

4 min read

Analyzing Teams data over a full year
Analyzing Teams data over a full year
Power Bi

4 min read


Nov 30, 2022

Using Paginated Reports in Power BI

On November 14th, Microsoft announced that paginated reports will no longer be limited to premium workspaces, but that any modern workspace can store paginated reports. That’s why in this post I’ll show you how to create a paginated report and add them to your “interactive” Power BI report. What are Paginated Reports? According to…

Power Bi

6 min read

Using Paginated Reports in Power BI
Using Paginated Reports in Power BI
Power Bi

6 min read


Sep 7, 2022

Adding external users to your Power BI workspace — Update

In one of my first blogs, I describe a method of how to add external people to your Power BI workspace. You can read that one here. Now there is a problem with that. Before, you got an e-mail with a link to that specific workspace and could access the…

Power Bi

2 min read

Adding external users access to your Power BI workspace — Update
Adding external users access to your Power BI workspace — Update
Power Bi

2 min read


Aug 9, 2022

Creating a dark and light theme for your Power BI report

Since I started working in BI, I saw a lot of colleagues using dark mode options, whenever they could. And when Microsoft revamped the desktop application to a light one, there were so many people asking for an option to change it back to dark. As far as I know…

Power Bi

4 min read

Creating a dark and light theme for your Power BI report
Creating a dark and light theme for your Power BI report
Power Bi

4 min read


Jul 27, 2022

Using the new Power BI — Data in space preview

With Data in space, Microsoft gives you the option to get an idea of what the future may look like. In an augmented reality experience, you can pin Power BI reports using Azure Spatial Anchors. …

Power Bi

4 min read

Using the new Power BI — Data in space preview
Using the new Power BI — Data in space preview
Power Bi

4 min read


Jul 14, 2022

Use Power Apps to write into Azure SQL Database

For a while, I wanted to create this demo, for which I’ll be using Power Apps to insert data into an Azure SQL database and show the results in our report. In this example, I’ll insert and update some records, refresh the page, and refresh the dataset using Power Automate…

Power Bi

8 min read

Use Power Apps to write into Azure SQL Database
Use Power Apps to write into Azure SQL Database
Power Bi

8 min read


May 30, 2022

Using the new Power BI Field Parameter to give your end-users more flexibility

When I was working for a customer two years ago, they requested to use the data hierarchy (Year, Month, Day) in a graph in Power BI. No problem, I included the hierarchy on the X-axis of multiple graphs and showed them how to use the drill-down option. But then they…

Power Bi

5 min read

Using the new Power BI Field Parameter to give your end-users more flexibility
Using the new Power BI Field Parameter to give your end-users more flexibility
Power Bi

5 min read


Mar 11, 2022

Using a geofence in Power BI

One of the clients I work for, got a request which includes geofencing. A geofence is a virtual perimeter for a real-world geographic area. It needs at least three different coordinates to create a shape. …

Power Bi

6 min read

Using a geofence in Power BI
Using a geofence in Power BI
Power Bi

6 min read


Mar 1, 2022

Getting data from the previous row in your table visual in Power BI

The problem Sometimes you want to have information from “the previous row” in your table. Problem is, your measures don’t have row context, so it doesn’t know on which row it is. Creating a column will solve this problem easily, but generally, it’s best practice to use measures. …

Power Bi

2 min read

Getting data from the previous row in your table visual in Power BI
Getting data from the previous row in your table visual in Power BI
Power Bi

2 min read


May 4, 2021

Power BI Goals, a new way in tracking your KPI’s

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…

Power Bi

3 min read

Power BI Goals, a new way in tracking your KPI’s
Power BI Goals, a new way in tracking your KPI’s
Power Bi

3 min read

Erik Hamoen

Erik Hamoen

38 Followers

Enthousiastic Power BI'er

Following
  • Arthur Steijn

    Arthur Steijn

  • Matthijs van der Steen

    Matthijs van der Steen

  • John Wilson

    John Wilson

  • Dylan van Riel

    Dylan van Riel

Help

Status

Writers

Blog

Careers

Privacy

Terms

About

Text to speech