Open in app

Sign in

Write

Sign in

Erik Hamoen
Erik Hamoen

50 Followers

Home

About

Aug 1

Creating a “Correlation Matrix” in Power BI

Recently I came across this question asked at the Power BI (Fabric) community, because I was looking for something like this myself. I had no idea what these matrices were called, but I think the correlation matrix will be in the best direction. With this example, I decided to try…

Power Bi

3 min read

Creating a “Correlation Matrix” in Power BI
Creating a “Correlation Matrix” in Power BI
Power Bi

3 min read


Jul 14

Gain interaction within your Center of Excellence

Intro It’s almost five years since I started working with Power BI, but since that day, there aren’t many without it. And I love to share my knowledge of it with others in the team I’m working with. I started writing blogs only for the team and put them in a…

Power Bi

4 min read

Gain interaction within your Center of Excellence
Gain interaction within your Center of Excellence
Power Bi

4 min read


Jun 13

Using Git integration with Power BI Desktop

With the June update of Power BI Desktop, a new preview feature arrived: the .pbip save option. This will create a Power BI project, just like how it is created when you link a workspace to Git, as described in my previous post. …

Power Bi

3 min read

Using Git integration with Power BI Desktop
Using Git integration with Power BI Desktop
Power Bi

3 min read


Jun 2

Power BI and Git integration

With Build 2023, Microsoft presented Git integration for Power BI workspaces (and later desktop, using pbip files and VS Code), but with workspaces in premium (PPU or PPC) you can already work with it! Let me show you how! In the Power BI Service I create two workspaces, one “production”…

Power Bi

4 min read

Power BI and Git integration
Power BI and Git integration
Power Bi

4 min read


May 29

Automatically change your Power BI theme by the time of the day

Last year I wrote a blog about using a dark and light theme in one Power BI report. In this follow-up post, I’ll show you how can automatically change the colors, based on the time of day. Using an API to retrieve the time of sunset and sunrise and some…

Power Bi

4 min read

Automatically change your Power BI theme by the time of the day
Automatically change your Power BI theme by the time of the day
Power Bi

4 min read


Mar 31

Using Power BI Visuals inside your PowerPoint presentation

We like to make jokes about PowerPoint being the first product of the Power Platform, and the fact that it’s a great tool for beginners to create Power BI report background images doesn’t help with that. But on a more serious note: Power BI recently introduced the option to add…

Power Bi

4 min read

Using Power BI Visuals inside your PowerPoint presentation
Using Power BI Visuals inside your PowerPoint presentation
Power Bi

4 min read


Mar 5

Show lineage between the tables on an Azure SQL DB and a Power BI Dataset

In my latest blog, I wrote about using the Apache Atlas API to get full lineage from source to Power BI dataset and report. A few days after that Microsoft made an update to the lineage capabilities, one that makes me really happy! When using Azure SQL DB as a…

Power Bi

5 min read

Show lineage between the tables on an Azure SQL DB and a Power BI Dataset
Show lineage between the tables on an Azure SQL DB and a Power BI Dataset
Power Bi

5 min read


Feb 13

Power BI & Microsoft Purview: Showing ‘full’ lineage from source to report

Intro Microsoft Purview (started as Azure Purview) is a Microsoft solution for data management, including a data catalog, data map (including the assets), and many more. Later they rebranded the whole Microsoft 365 compliancy center to Purview, making it more logical to call it Microsoft Purview, rather than Azure Purview…

Power Bi

5 min read

Power BI & Microsoft Purview: Showing ‘full’ lineage from source to report
Power BI & Microsoft Purview: Showing ‘full’ lineage from source to report
Power Bi

5 min read


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

Erik Hamoen

Erik Hamoen

50 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

See all (5)

Help

Status

About

Careers

Blog

Privacy

Terms

Text to speech

Teams