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

Tag: power bi

Book Review – Microsoft Power BI Performance Best Practices

November 19, 2024November 25, 2024 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, 2024November 16, 2024 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, 2024November 14, 2024 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, 2024September 19, 2024 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

Power BI Field Parameters and Slowly Changing Dimensions

June 17, 2022June 17, 2022 Koen Verbeeck Leave a comment

Power BI field parameters are a new feature in Power BI Desktop, and it’s one of the best of the past months. In short, Power BI field parameters allow you to easily switch between dimensions attributes or measures in a filter. Previously, you had to do all sorts of DAX wizardry to make this happen, […]

Read More

Azure Function with PowerShell and the Power BI REST API

April 26, 2022April 26, 2022 Koen Verbeeck Leave a comment

In this blog post I’m going to show you how you can create an Azure Function that will interact with the Power BI REST API. I choose PowerShell as the programming language because in my opinion it was a bit easier to authenticate with the Power BI service. For the development environment, I’m using Visual […]

Read More

DirectQuery to Power BI Datasets

February 25, 2022February 25, 2022 Koen Verbeeck Leave a comment

A new feature has been added to the Power BI Desktop toolset and it’s a very nice one. The official name is “DirectQuery for PBI datasets and AS”. It allows you to create a connection to an existing model (either Analysis Services or a Power BI dataset) and link tables from that model into your […]

Read More

STAR SCHEMA ALL THE THINGS

February 25, 2021February 25, 2021 Koen Verbeeck Leave a comment

The title says it all, but I’ll explain it anyway. When building a data model that will be used for analysis by human beings, always create a star schemas. Or multiple star schemas connected with conformed dimensions. Why? Because it’s the most intuitive and user-friendly interface. Because remember, your data model is the user interface […]

Read More

Posts pagination

1 2 … 5 Older posts

Feed

RSS

Social

  • Twitter
  • LinkedIn

MVP

Microsoft Data Platform MVP

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

  • Techorama 2025 – Slides
  • Redgate SQL Prompt in SSMS 21
  • Execute Fabric Data Pipeline from Azure Data Factory
  • Azure Data Factory Pipeline Debugging Fails with BadRequest
  • Call a Fabric REST API from Azure Data Factory

Categories

  • Azure (25)
  • Azure Data Factory (25)
  • Azure Devops (4)
  • Book Review (26)
  • Business Intelligence (29)
  • Events (57)
  • Fabric (19)
  • Power BI (41)
  • Professional Development (9)
  • Snowflake (14)
  • SQL Server (113)
    • 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