Press "Enter" to skip to content

Day: October 20, 2026

Working with the Power BI Gantt Chart

Published 2026-10-20 by Kevin Feasel

Valerie Junk tries out a new built-in visual:

Almost every company runs projects or has some kind of timeline, and most of the time that planning is tracked somewhere else, for example, in an Excel file or in another tool. But at the same time, most of our data is already in Power BI. Until now you basically had two options:

  • A custom visual which might need a paid license.
  • A workaround you build yourself, like a stacked bar chart or a matrix with conditional formatting, which works, but every change means fixing your own workaround.

It looks fairly reasonable, though I do hope the Power BI team is able to relax some of those restrictions before it goes GA. Because I’m only so much of a masochist, I didn’t look up whether Power BI Report Server will include this visual. Maybe it will three years from now.

Leave a Comment

Full-Text Indexing and Power BI Semantic Model Refresh Times

Published 2026-10-20 by Kevin Feasel

Chris Webb runs a test:

The September release of Power BI saw the introduction of a powerful new feature: full text indexing, which makes searching and filtering on text columns much faster and enables the use of the new TextContains() and TextSimilarity() DAX functions. You need to enable it on a per-column basis and when you do that you have the option to rebuild the full-text index for those columns when you do a Full refresh or when you do a refresh of the type Indexes. So the big question is: how long does it take to build a full-text index on a column and what impact will it have on your overall refresh times?

Read on for that answer in a reasonably-sized dataset containing street addresses.

Leave a Comment

Building an Isolated Hyper-V Network for Azure Communications

Published 2026-10-20 by Kevin Feasel

Jordan Boich continues a series on networking for the DBA:

Before I even touched anything related to Azure, I needed to make sure that nothing I did could impact my Wi-Fi at home. The whole reason why I love home lab environments so much is because it is contained end to end. If I break something in my lab, it’s comforting to know that nothing important will ever be in that blast radius. This post is all about hitting the prerequisites that don’t touch anything important like setting up an isolated lab network, save points for my existing VMs, license checks, and creating an Azure subscription that doesn’t touch anything else.

Read on to see what Jordan did.

Leave a Comment

Connecting Azure Databricks to a Microsoft Foundry AI Gateway

Published 2026-10-20 by Kevin Feasel

Drew Furgiuele connects the dots:

While some people might look at the different capabilities and think this is an “either/or” scenario, the reality is that most Azure customers are going use (or even need to use) both: developers building apps and agents in Databricks, for example, may want to leverage a model or other agent deployed in Foundry. Meanwhile, developers in Foundry may need to call a Databricks managed MCP service.

These types of calls aren’t all that difficult; in fact, both platforms provide built-in connectors or UI solutions to make this happen: simply provide the service endpoint, pick your authentication method, and you’re pretty much done. However, the introduction of the respective gateways, especially on the Foundry side, can make this just a little more complicated. Let’s look at one example.

Click through for that issue and how Drew was able to work around it.

Leave a Comment

Creating an Azure DevOps Deployment

Published 2026-10-20 by Kevin Feasel

Reitse Eskens deploys some Microsoft Fabric assets:

Let me generalise first: you can essentially choose two options to promote your hand-crafted and superior code compared to anyone else from development to production. The first way is to use the Fabric deployment pipelines. These are essentially copy actions that move the development state to production. Option two is to use either GitHub Actions or Azure DevOps pipelines.

The main issue I’ve seen with the Fabric deployment pipelines is that the deployed code still references the development environment. This results in your notebook running in production and happily writing the results in the development lakehouse. To mitigate this, you can add actions to the Fabric pipeline, check out the newly announced Fabric deployment plans, or remember to update all references.

Click through for a high-level depiction of the process.

Leave a Comment

Testing Immutable SQL Server Backups

Published 2026-10-20 by Kevin Feasel

Warwick Rudd tries to make a change:

In Part 1 we built an immutable container. In Part 2 we gave the SQL Server 2025 VM a Managed Identity and Microsoft Entra authentication. This is where it comes together. We’ll keep the traffic between SQL Server and storage on the private network, lock down who can reach the storage account, give the VM permission to write, and then take a backup and try to delete it.

Read on for those steps.

Leave a Comment