Using Data Factory Global Parameter in Power Query

[SanderTK]

Hi all,

I am working with a Power Query in my ADF pipeline to filter some data from a dataset.

The intention is to set a global parameter and use that parameter inside Power Query to filter the data.

My thoughts are that I would have to incorporate the parameter with the M-query (inside the advanced editor) but I am not entirely sure how to pass that global parameter.

Is this possible and if so how would I pass on this parameter?

[frithjof_v · Accepted solution]

I don't think the pipeline can pass the parameter directly into Power Query.

I think you will need to store the "parameter" as a cell value in an external table (or file), and then connect Power Query to that table in order to read the value of the "parameter".

Related threads (if you are using Fabric Data Pipeline): 

Solved: Pass data pipeline parameter to dataflow gen2 - Microsoft Fabric Community

Please vote here to make this possible: https://ideas.fabric.microsoft.com/ideas/idea/?ideaid=2f761603-a400-ee11-a81c-6045bdb98602

Related threads (if you are using Azure Data Factory): 

Solved: Dynamic PowerQuery using ADF - Microsoft Fabric Community

azure - Pass Parameters/Values from Pipeline into Power Query Activity in ADF - Stack Overflow