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

Tag: adf

Execute Fabric Data Pipeline from Azure Data Factory

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

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 Leave a 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

Planview Portfolios REST API with ADF – Retrieving Actual Data

May 26, 2024May 26, 2024 Koen Verbeeck Leave a comment

In the introduction of this blog post series, I explained the use case: extracting data from the Planview Portfolios REST API using Azure Data Factory. Any tool that can send HTTPS requests can work with the REST API, but our focus here is ADF (which can also be Synapse Pipelines or Fabric Pipelines). In the […]

Read More

Planview Portfolios REST API with ADF – The OData Feed

May 26, 2024May 26, 2024 Koen Verbeeck Leave a comment

In the introduction, I explained the setup of the use case and why we need to use the OData feed: to get the list of Project IDs, because the REST API doesn’t have an endpoint for this. Weird, right? In this part of the series, we’ll dive into the Lookup activity, which uses the OData […]

Read More

Extracting Data from the Planview Portfolios REST API using ADF – Introduction

May 26, 2024May 27, 2024 Koen Verbeeck Leave a comment

I have a client using Planview Portfolios to manage their PMO. As part of the data warehouse, we want to extract the project data from the Planview REST API. There are other methods to get data, such as using OData (which is used in the Power BI connector), SOAP Web Services (2005 called) and a […]

Read More

t-sql tuesday long

#TSQL2sday 171 – Describe the Most Recent Issue You Closed

February 13, 2024February 13, 2024 Koen Verbeeck Leave a comment

It’s #TSQL2sday time! This month’s invitation has been sent out by Brent Ozar and he asks us to describe the most recent issue – or the last ticket – we closed. In my case, I actually blogged about it in this blog post: Azure Function App doesn’t retrieve most recent secret value from Azure Key […]

Read More

Posts pagination

1 2 … 4 Older posts

Feed

RSS

Social

  • Twitter
  • LinkedIn

MVP

Microsoft Data Platform MVP

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

  • Techorama 2025 – Slides
  • Redgate SQL Prompt in SSMS 21
  • Execute Fabric Data Pipeline from Azure Data Factory
  • Azure Data Factory Pipeline Debugging Fails with BadRequest
  • Call a Fabric REST API from Azure Data Factory

Categories

  • Azure (25)
  • Azure Data Factory (25)
  • Azure Devops (4)
  • Book Review (26)
  • Business Intelligence (29)
  • Events (57)
  • Fabric (19)
  • Power BI (41)
  • Professional Development (9)
  • Snowflake (14)
  • SQL Server (113)
    • 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