Microsoft Fabric Archives - Hat Full of Data

11th February 2026

Using Variable Library in a Dataflow

One of the popular low-code tools within Microsoft Fabric is the Gen2 Dataflow. Power BI report builders already know some Power Query. So armed with this knowledge is a popular starting point to load data into Microsoft Fabric. Adding values from the Variable Library in a Dataflow is an obvious plan to make it more future proof and to work...

Dataflows/Microsoft Fabric/Variable Libraries Comment: 1

26th January 2026

Using a Variable Library in Lakehouse Shortcuts

Lakehouse shortcuts are a popular addition to the Fabric set of tools to access data easily without copying it. Using a variable library in lakehouse shortcuts means its easy to point shortcuts to an alternative location. This great for ALM using development, test and production workspaces. Setting Up the Shortcuts Using the standard GUI you have no option to use...

Microsoft Fabric/Variable Libraries Comments: 2

19th January 2026

Using a Variable Library in a Data Pipeline

You’ve set up your variable pipeline with WorkspaceIDs and LakehouseIDs etc etc Now you want to use that variable library in a data pipeline so we can use the common values and they will behave in a deployment pipeline. Adding the Variables to the Data Pipeline Before you can use the variable library in a data pipeline you need to...

Data Pipeline/Microsoft Fabric/Variable Libraries Comments: 2

12th January 2026

Accessing a Variable Library in a Notebook

This post walks through how to access a variable library in a notebook in Microsoft Fabric. I recommend a Microsoft Fabric project starts by creating a variable library to store the common values different artifacts need and could be changed if a deployment pipeline gets involved. So when we create a notebook we need to be able to use these...

Microsoft Fabric/Notebooks/Variable Libraries Comment: 1

6th January 2026

Microsoft Fabric – Variable Library

This post to help you get started creating a variable library. When multiple dataflows, notebooks and pipelines are using the same details to perform tasks it helps if those values are stored in one place. When you move to use deployment pipelines and those values change from your development workspace to your test workspace to your prod, it helps if...

Microsoft Fabric/Variable Libraries Comment: 1

27th November 2025

Microsoft Fabric – Using Copy Job with Dataverse

Dataverse is the data store behind parts of Dynamics and lots of Power Platform projects. So Dataverse can contain vital business data that will be needed for reporting. In this post we are going to look at one method which is using copy job with Dataverse to copy across data in Microsoft Fabric. Scenario For this post we will look...

Dataverse/Microsoft Fabric Comments: 3

7th November 2025

Microsoft Fabric – Direct Lake and User Permissions

Direct Lake is the best way to build a semantic model on data in a Lakehouse or a Warehouse. We can then use Power BI to build reports and possibly even a make a Workspace App to deliver those reports to the business. So what permissions do the business users need to view those reports? This post will explore using...

Microsoft Fabric/Power BI

26th August 2025

Lewis and Laura vs. Notebook and Microsoft Graph: Part 2

A recent project made me reach out to Lewis Baybutt to scream “Help!, I need help getting with authentication for an Excel file in SharePoint in a Microsoft Fabric Notebook”. Yes all the delights of Excel and SharePoint in one project. So started the battle with understanding authentication, permissions and apparently a Notebook and Microsoft Graph is the way. The...

Microsoft Fabric/Microsoft Graph

21st August 2025

Get Secret from Azure Key Vault in a Microsoft Fabric Notebook

I’ve recently been working with Notebooks in Microsoft Fabric and have needed to get a credentials information that should be kept secure. The obvious place to store such credentials is Azure Key Vault so now we need to get our secret from there. This is a really short post to help me out when I need a fast explanation on...

Azure/Microsoft Fabric

5th June 2025

Microsoft Fabric – Create a Data Pipeline with Parameters

One of the skills of creating good solutions on any platform is building reusable modules. For a part to be reusable we reduce the hard coding and pass in parameters. This is true for data pipelines. So this post post covers creating a data pipeline with parameters. Initial Scenario In order to demonstrate how to create a data pipeline with...

Microsoft Fabric

Category: Microsoft Fabric