14 February 2024
14 February 2024

4 Rules to follow on Microsoft Fabric Source Control

Power BI and Fabric are implementing source control support. It’s a long-awaited feature for Power BI. However, it’s important to highlight some basic principles which should be followed as source control best practices. Some of them apply to any project in source control, some are specific for this environment, and some are specific for this … Read more
01 February 2024
01 February 2024

Feature Flags in Data Projects

My motivation for writing this summary was an interaction with a project owner that didn’t understand why we couldn’t use feature flags directly in Power BI to control the user interface. This was different from our other deployments, so it took a few rounds of explanations to convince them that our use case didn’t support … Read more
23 January 2024
23 January 2024

Power BI and Resource Graph: Why you should care

Recently Azure Resource Graph was announced as a new connector in Power BI. Azure Resource Graph provides access to almost all resources inside the azure environment of a company. Why is this important? Resource Graph by itself is a very important tool to analyze the provisioned resources on Azure environment without lose the control of … Read more
17 January 2024
17 January 2024

Fabric and Self-Service: Control who can use

We can say Fabric is the evolution of the Power BI environment. Power BI is a self-service environment, and so is Fabric. This allows the implementation of very interesting architectures, which will be the subject of future videos and articles. However, it’s not something free-and-easy, and it shouldn’t be. Using Fabric Admin Portal (or Power … Read more
10 January 2024
10 January 2024

Semantic Model: More than a Simple Name Change

The animation on the top of this article tries to track the evolution of the enterprise architecture since SQL Server 7.0 introduced tools for ETL, Semantic model and much more. Some of you probably remember these tools as SSIS and SSAS. At that time they had even older names, but no one wants to confess remembering … Read more
31 December 2023
31 December 2023

Warehouse Load Patterns – Part 2 – Load Patterns

This continues and finishes my two-part series on warehouse load patterns. There are many methods to transfer rows between systems from a basic design perspective. This isn’t specific to any ETL tool but rather the basic patterns for moving data. The most difficult part in designing a pattern is efficiency. It has to be accurate … Read more
13 December 2023
13 December 2023

Fabric Notebooks and Deployment Pipelines

On my article about Fabric source control extended features, I explained how Microsoft included the notebooks on the source control. In this way we can include notebooks on a Software Development Lifecycle (SDLC) for Power BI objects. In this way, the notebooks need to flow from the development environment to test and production environments. However, … Read more
08 December 2023
08 December 2023

What Counts For a DBA: Duty

It has been a long month. We had the PASS Data Community Summit just a month ago, and I came home with a hitchhiking virus (no, not that one). I dragged through Thanksgiving, got better, and went on vacation. I got back home from vacation, and, well, I was sick again. Looking at my calendar … Read more
29 November 2023
29 November 2023

Microsoft Fabric: Extended Source Control Features

The source control features in Microsoft Fabric are evolving every day. The PBIP feature included in Power BI allowed us to include source control on a SDLC process for Power BI, supporting reports and datasets linked directly from the portal to a repository. The New Source Control Features Recently, without much news, Microsoft extended the … Read more
26 November 2023
26 November 2023

Updates about Database Projects for Microsoft Fabric

comp A few weeks ago, I wrote a blog about Database Projects for Microsoft Fabric. It’s an interesting advance, but it was disappointing because it was only available in half. Updating the Fabric Data Warehouse was not possible yet. The November updates for Microsoft Fabric announces the support for SQLPackage, but I couldn’t find additional … Read more
16 November 2023
16 November 2023

PASS Summit 2023 – Redgate Keynote – The New Database Landscape – Revealing Shifts and Charting the Next Horizon

Day 2 is here! Sitting here at the bloggers table waiting for the keynote to commence!   Note: if you aren’t into the whole brevity thing, you can view then entire keynote on YouTube here. Carly Miechen – Redgate Events Welcome to day 2. Let the Event team this year! (Great job Carly). Carly’s fifth … Read more
15 November 2023
15 November 2023

Microsoft Fabric: Using VS Code to Develop Notebooks

The possibility to use Visual Studio Code (or VS Code) to develop your Microsoft Fabric notebooks seems very interesting. It may bring many benefits for usability and for the SDLC (Software Development lifecycle): You may prefer developing on your own machine than on the interface of a portal It’s possible to develop and test before … Read more