Skip to main content
Under the kover of business intelligence
  • Home
  • Copyright
  • About

Tag: power bi

Retro Data 2025 – Slidedeck

September 20, 2025September 20, 2025 Koen Verbeeck Leave a comment

You can find the slides of my session on the €100 DWH in Azure on Github.

Read More

Free Online Sessions – Building the €100 DWH and Indexing for Dummies

September 11, 2025September 11, 2025 Koen Verbeeck Leave a comment

I’m giving two online sessions soon on virtual events that are free to attend. The first one is at Retro Data (20th of September), a new virtual conference focusing on established technology, instead of preview features. My session Building the €100 data warehouse with the Azure Data Platform at 10AM UTC+2. The other session is […]

Read More

Power BI dataflow Gen1 needs Gateway to connect to Azure SQL DB

August 20, 2025August 20, 2025 Koen Verbeeck Leave a comment

I’m in the progress of migrating some legacy stuff at a client, and in their Power BI environment there are still quite some Power BI dataflows Gen1. I had migrated an Azure Synapse Dedicated SQL Pool to an Azure SQL DB (much cheaper for their volume of data), and in the dev/test environment all dataflows […]

Read More

Free Webinar – Build a data warehouse on Azure Data Platform for $150

June 11, 2025June 11, 2025 Koen Verbeeck Leave a comment

I’m presenting a free webinar at MSSQLTips.com at Thursday, July 10, 2025 at 6PM UTC (8PM CET or 2PM EDT). The abstract: As you might learn from the abstract, the session is aimed at people working with “small data”. Just a couple of gigabytes, biggest table is below 100 million rows. But you would be […]

Read More

Book Review – Microsoft Power BI Performance Best Practices

November 19, 2024July 30, 2025 Koen Verbeeck Leave a comment

I was asked to do a review of the book Microsoft Power BI Performance Best Practices 2nd edition (Amazon link), which means I got a copy for free. The book is written by Thomas Leblanc and Bhavik Merchant and published by Packt. As the title obviously implicates, the book aims to give you a set […]

Read More

Create a Numbers Table in Power Query

November 15, 2024July 30, 2025 Koen Verbeeck Leave a comment

This is a quick blog post, mainly so I have the code available if I need it somewhere in the future 🙂 Sometimes you need a numbers table (also called tally table) when you’re working with data. It’s a table with one single integer column that contains incremental numbers (0,1,2,3,4,…). In a database, it’s fairly […]

Read More

Microsoft finally adds Tenant Switcher for Fabric / Power BI

November 14, 2024July 30, 2025 Koen Verbeeck Leave a comment

Praise whatever deity you believe in, because it’s finally here, a tenant switcher for Microsoft Fabric (which includes Power BI). A what? Let me explain. When you have a organization with multiple tenants in Azure (also called directories in some products like Azure Devops), or you’re a consultant like me who works with multiple clients […]

Read More

Connect to Power BI as a Guest User in another Tenant

September 19, 2024July 30, 2025 Koen Verbeeck 3 Comments

Sometimes your Microsoft Entra ID account (formerly known as Azure Active Directory) is added as a guest user in another tenant. This happens quite a lot when you’re a consultant and your client can’t create a new user in their own tenant, so they add the account of your own company as a guest instead. […]

Read More

How to Calculate Compound Rate in Power BI

September 29, 2022September 29, 2022 Koen Verbeeck Leave a comment

Recently I had an interesting use case where I had to a compound calculation in Power BI. You can compound an interest rate for example, where you get a certain rate on your savings. Let’s say 1% (which is at the time of writing ridiculously high, but bear with me). After 1 year, you get […]

Read More

Power BI Desktop overwrites Authentication Settings in Similar Connections

September 13, 2022September 13, 2022 Koen Verbeeck 5 Comments

Yesterday I was facing an annoying issue. I have two Power BI datasets. Both connect to the same Azure SQL database, but with different SQL users (they have both different permissions on the data in the database). This can be a use case for example where you have data for multiple clients inside one single […]

Read More

Posts pagination

1 2 … 5 Older posts

Feed

RSS

Social

  • Twitter
  • LinkedIn

Former MVP

Former Microsoft Data Platform MVP (2017-2025)

star schema all the things
Get your star schema merchandise

Author of the Year 2014/2020/2023

Support this blog and buy me a beer

Recent Posts

  • dataMinds Connect 2025 – Slides & Scripts
  • Cloud Data Driven User Group 2025 – Slides & Scripts
  • Retro Data 2025 – Slidedeck
  • Secure Logic Apps with OAuth Authorization
  • Free Online Sessions – Building the €100 DWH and Indexing for Dummies

Categories

  • Azure (28)
  • Azure Data Factory (27)
  • Azure Devops (5)
  • Book Review (26)
  • Business Intelligence (29)
  • Events (61)
  • Fabric (19)
  • Power BI (42)
  • Professional Development (9)
  • Snowflake (14)
  • SQL Server (114)
    • MDS (8)
    • SSAS (12)
    • SSIS (46)
    • SSRS (13)
    • TSQL (9)
  • Varia (37)
  • Twitter
  • LinkedIn
  • Home
  • Copyright
  • About
Under the kover of business intelligence All rights reserved. Theme by Colorlib Powered by WordPress