Konverga
open-menu closeme
Home
Categories
Series
Timeline
github linkedin
  • Configure dbt with MS Fabric in VS Code with the dbt Power User extension

    calendar Oct 21, 2025 · 7 min read · Visual Studio Code  ·
    Share on: twitter facebook linkedin copy
    Configure dbt with MS Fabric in VS Code with the dbt Power User extension

    Lately, I’ve been setting up dbt Cloud to work with Microsoft Fabric. We started out using dbt’s browser-based IDE, but as our number of models grew, I began to miss Visual Studio Code. First, a quick distinction: dbt Core is the open-source command-line tool for local development, while dbt Cloud is the managed …


    Read More
  • Automating File Transfers to Microsoft Fabric with PowerShell and AzCopy

    calendar Jun 24, 2025 · 6 min read · AzCopy  ·
    Share on: twitter facebook linkedin copy
    Automating File Transfers to Microsoft Fabric with PowerShell and AzCopy

    Last year, I shared my experience with managing files in OneLake using the Python SDK, where I explored how to programmatically interact with Microsoft Fabric’s data lake capabilities. Recently, I revisited a similar challenge — but this time, I approached it from a different angle. Instead of Python, I used PowerShell …


    Read More
  • Unity Catalog with Azure Databricks - First Impressions

    calendar May 5, 2025 · 7 min read  ·
    Share on: twitter facebook linkedin copy
    Unity Catalog with Azure Databricks - First Impressions

    This blog post shares my first experience working with Unity Catalog on Azure Databricks. Although it’s been over six months since I completed this proof-of-concept, I wanted to document it before the details faded entirely. While not everything is still fresh in my mind, revisiting the process turned out to be a …


    Read More
  • Fabric and dbt Cloud - First Impressions

    calendar Apr 18, 2025 · 6 min read  ·
    Share on: twitter facebook linkedin copy
    Fabric and dbt Cloud - First Impressions

    I recently had the chance to work on a proof of concept combining dbt Cloud with Microsoft Fabric. It was a great opportunity to explore how well these two platforms work together. In this blog post, I'll share my first impressions. What I really liked Data Tests Unit Testing Integration Testing Data Health Tiles Two …


    Read More
  • Managing files in a Fabric Lakehouse using the Python Azure SDK

    calendar Jan 11, 2024 · 4 min read · Python SDK Pipelines  ·
    Share on: twitter facebook linkedin copy
    Managing files in a Fabric Lakehouse using the Python Azure SDK

    In this blogpost, you’ll see how to manage files in OneLake programmatically using the Python Azure SDK. Very little coding experience is required and yet you can create very interesting automations this way. I started testing this approach when I was creating a proof-of-concept. I was working on a virtual machine …


    Read More
  • Bringing Python to Azure Data Factory with Azure Batch Service

    calendar Dec 16, 2021 · 19 min read  ·
    Share on: twitter facebook linkedin copy
    Bringing Python to Azure Data Factory with Azure Batch Service

    Azure Data Factory (ADF) is a cloud-based Extract-Transform-Load (ETL) and data integration service. It allows you to create data-driven workflows for orchestrating data movement and transforming data at scale. Through a simple drag-and-drop interface the tool ensures that processes are easy to maintain. In most cases …


    Read More
  • Concurrent API requests with Python by example

    calendar Oct 21, 2021 · 13 min read · API Concurrency  ·
    Share on: twitter facebook linkedin copy
    Concurrent API requests with Python by example

    APIs are one of the things we often come across when working with data. In this blogpost we’ll have a look at some ways of extracting data out of them with Python in an efficient way. For small amounts of data we could write a simple script that sends one request at a time. For large amounts of data this is no longer a …


    Read More
  • Avoid headaches when working with separate PBIX files in Power BI

    calendar May 5, 2021 · 6 min read  ·
    Share on: twitter facebook linkedin copy
    Avoid headaches when working with separate PBIX files in Power BI

    Splitting datasets and reports into separate PBIX files is a very common way of managing Power BI reports. This approach keeps data and calculations in a more central repository which acts as a “Single Source of Truth”. But dividing sets and reports can result in a headache or two. Let our blog be your Power BI …


    Read More
  • Running Python scripts on Azure with Azure Container Instances

    calendar Dec 14, 2020 · 17 min read  ·
    Share on: twitter facebook linkedin copy
    Running Python scripts on Azure with Azure Container Instances

    In this post, I’ll walk through how to set up a container that reads a file from an Azure file share and writes the content to a blob container. It’s a relatively simple task, but it’s a great way to highlight the core features of ACI. We’ll use a managed identity to securely access an Azure Key Vault, mount an Azure …


    Read More
  • Oops I lost my Excel password

    calendar Sep 9, 2018 · 5 min read · Access Recovery  ·
    Share on: twitter facebook linkedin copy
    Oops I lost my Excel password

    Excel files are used in nearly every workplace and are frequently shared between people. It's not uncommon for passwords to get lost, leaving you locked out of your own files. In this blog post, I'll walk you through the process of regaining access to Excel files protected at the sheet, workbook, or VBA-project level. …


    Read More
    • ««
    • «
    • 1
    • 2
    • »
    • »»

Johan Hostens photo

Johan Hostens

Freelance Azure Data Engineer

Passionate about

  • Databricks
  • Python
  • SQL

Featured Posts

  • Configure dbt with MS Fabric in VS Code with the dbt Power User extension
  • Automating File Transfers to Microsoft Fabric with PowerShell and AzCopy
  • Unity Catalog with Azure Databricks - First Impressions
  • Fabric and dbt Cloud - First Impressions
  • Managing files in a Fabric Lakehouse using the Python Azure SDK
  • Oops I lost my Excel password

Recent Posts

  • Bringing Python to Azure Data Factory with Azure Batch Service
  • Concurrent API requests with Python by example
  • Avoid headaches when working with separate PBIX files in Power BI
  • Running Python scripts on Azure with Azure Container Instances
  • Compare Ranges in Excel

Categories

MICROSOFT FABRIC 4 DBT 2 EXCEL 2 PYTHON 2 AZURE BATCH 1 AZURE CONTAINER INSTANCES 1 DATABRICKS 1 POWER BI 1 POWERSHELL 1 UNITY CATALOG 1

Series

DATA ENGINEERING 6 DATA QUALITY 1 PERFORMANCE 1 REPORTING 1 SECURITY 1

Tags

ACCESS RECOVERY 1 API 1 AZCOPY 1 CONCURRENCY 1 PIPELINES 1 PYTHON SDK 1 VBA 1 VISUAL STUDIO CODE 1
Konverga

Copyright  KONVERGA. All Rights Reserved

to-top