Learn how to use Power Automate to automatically pause a Microsoft Fabric capacity on a schedule and save costs. This step-by-step guide shows how to check the current capacity state and only suspend it when it is Active.
modifying Microsoft Fabric FUAM monitoring tool to also report on shared capacity workspaces.
Create a Microsoft Fabric variable library directly from a Python notebook it can all be automated via code. I'm also fed up of building demos by hand.
Fixing daylight saving and summer time issues in Power Query with a simple pattern to stop dates becoming a day earlier.
How precisely does a variable library work with a deployment pipeline? This post walks through changing a value at different stages of your deployment.
MVP Renewal day come around, so here is my Humbled and Honoured post
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...
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...
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...
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...
