Is there any way to use power query within the data factory and Self-hosted Integration runtime?

Saša 1 Reputation point
2022-08-25T15:30:28.787+00:00

Hey there,

we'd like connect to our Azure SQL Database within the data factory and use a Power Query for transformations. The linked service is with Self-hosted Integration runtime, but that doesn't work.

"Linked service with Self-hosted Integration runtime is not supported in "Power Query". "

Creating a blob wouldn't work either since we are using Self hosted IR there too.

Is there any way to use power query within the data factory and Self-hosted Integration runtime?

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
6,670 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. MarkKromer-MSFT 5,146 Reputation points Microsoft Employee
    2022-08-26T08:12:15.647+00:00

    Power Query scripts in ADF convert into Mapping Data Flows. To connect to on-prem or vnet secured data stores in ADF data flows (or PQ), you need to configure the Azure IR for Vnet and follow these steps: https://learn.microsoft.com/en-us/azure/data-factory/tutorial-data-flow-private