Skip to main content
Under the kover of business intelligence
  • Home
  • Copyright
  • About

Tag: adf

Retro Data 2025 – Slidedeck

September 20, 2025September 20, 2025 Koen Verbeeck Leave a comment

You can find the slides of my session on the €100 DWH in Azure on Github.

Read More

Secure Logic Apps with OAuth Authorization

September 17, 2025September 17, 2025 Koen Verbeeck Leave a comment

I’ve used Logic Apps a couple of times over the past years for simple workflows, like sending an email (still not supported in ADF, booooo), reading a SharePoint List or copying some files from A to B (cheaper than the Copy Data Activity in ADF). When you create a Logic App with an HTTP trigger […]

Read More

Free Online Sessions – Building the €100 DWH and Indexing for Dummies

September 11, 2025September 11, 2025 Koen Verbeeck Leave a comment

I’m giving two online sessions soon on virtual events that are free to attend. The first one is at Retro Data (20th of September), a new virtual conference focusing on established technology, instead of preview features. My session Building the €100 data warehouse with the Azure Data Platform at 10AM UTC+2. The other session is […]

Read More

Parameterize Linked Service in ADF with no Dynamic Content available

June 26, 2025June 26, 2025 Koen Verbeeck Leave a comment

When you create linked services in Azure Data Factory (ADF) or in a Synapse Workspace, you typically want to parameterize certain properties of the connection. When you deploy your artefacts to another environment, you can change the parameter values to switch the connection to the new environment. For example, the server name of the connection […]

Read More

Execute Fabric Data Pipeline from Azure Data Factory

April 28, 2025April 28, 2025 Koen Verbeeck 3 Comments

In the blog post Call a Fabric REST API from Azure Data Factory I explained how you can call a Fabric REST API endpoint from Azure Data Factory (or Synapse if you will). Let’s go a step further and execute a Fabric Data Pipeline from an ADF pipeline, which is a common request. A Fabric […]

Read More

Azure Data Factory Pipeline Debugging Fails with BadRequest

April 4, 2025April 4, 2025 Koen Verbeeck Leave a comment

I recently had a new pipeline fail. It was actually a copy of an old pipeline where I had made some adjustments into as part of a database migration. When triggered during an execution run, it failed saying some expression could not be parsed. When I went into the pipeline and triggered a debug, it […]

Read More

Call a Fabric REST API from Azure Data Factory

April 1, 2025April 1, 2025 Koen Verbeeck 1 Comment

Suppose you want to call a certain Microsoft Fabric REST API endpoint from Azure Data Factory (or Synapse Pipelines). This can be done using a Web Activity, and most Fabric APIs now support service principals or managed identities. Let’s illustrate with an example. I’m going to call the REST API endpoint to create a new […]

Read More

How to use a Script Activity in ADF as a Lookup

June 27, 2024June 27, 2024 Koen Verbeeck 1 Comment

In Azure Data Factory (ADF, but also Synapse Pipelines and Fabric Pipelines), you have a typical scenario where you retrieve some metadata from a database and then loop over the metadata with a ForEach activity. For example, to copy all the table from a source database in a metadata-driven pipeline. The obvious choice would be […]

Read More

Dynamic Warehouse & Lakehouse Connections in Microsoft Fabric Data Pipelines

June 13, 2024June 14, 2024 Koen Verbeeck 3 Comments

When you develop data pipelines in Microsoft Fabric (the Azure Data Factory equivalent in Fabric, not to be confused with deployment pipelines), you will most likely have some activities with a connection to a warehouse, a lakehouse or a KQL database (for the remainder of the blog post I’ll talk about a warehouse, but it […]

Read More

PostgreSQL error in Fabric Pipelines – No pg_hba.conf Entry for Host

June 7, 2024June 7, 2024 Koen Verbeeck Leave a comment

I came across a bit of a weird error when I was trying to connect to a PostGreSQL database (hosted as an Azure DB for PostGreSQL), where “xx.xx.xx.xxx” is some IP address: No pg_hba.conf entry for host “xx.xx.xx.xxx” Some context to get us started. I’m using Pipelines in Microsoft Fabric to copy data from an […]

Read More

Posts pagination

1 2 … 5 Older posts

Feed

RSS

Social

  • Twitter
  • LinkedIn

Former MVP

Former Microsoft Data Platform MVP (2017-2025)

star schema all the things
Get your star schema merchandise

Author of the Year 2014/2020/2023

Support this blog and buy me a beer

Recent Posts

  • dataMinds Connect 2025 – Slides & Scripts
  • Cloud Data Driven User Group 2025 – Slides & Scripts
  • Retro Data 2025 – Slidedeck
  • Secure Logic Apps with OAuth Authorization
  • Free Online Sessions – Building the €100 DWH and Indexing for Dummies

Categories

  • Azure (28)
  • Azure Data Factory (27)
  • Azure Devops (5)
  • Book Review (26)
  • Business Intelligence (29)
  • Events (61)
  • Fabric (19)
  • Power BI (42)
  • Professional Development (9)
  • Snowflake (14)
  • SQL Server (114)
    • MDS (8)
    • SSAS (12)
    • SSIS (46)
    • SSRS (13)
    • TSQL (9)
  • Varia (37)
  • Twitter
  • LinkedIn
  • Home
  • Copyright
  • About
Under the kover of business intelligence All rights reserved. Theme by Colorlib Powered by WordPress