Open in app

Sign In

Write

Sign In

Erik Hamoen
Erik Hamoen

44 Followers

Home

About

5 days ago

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

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


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

Erik Hamoen

Erik Hamoen

44 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

Writers

Blog

Careers

Privacy

Terms

About

Text to speech

Teams