Forum Discussion
Producing Dynamic SQL in Dataflow
As we can't currently pass parameters from Pipeline to Dataflow in Fabric, a workaround is to access Dynamic SQL from a txt file. We can use Table.FirstValue to read the first row of a txt file ...
Hi,
I was just sharing a workaround for passing parameters into a Dynamic SQL query as we can't directly pass parameters to a Dataflow.
The snippet above was intended for anyone who wanted to do the same.
If you create a basic Gen2 Dataflow, and add a datasource....
then modify the code generated to read the Dynamic SQL from a file and parse it into the Query.
Anonymous Very useful - thanks