Forum Discussion
JohnG_PIT
Apr 13, 2024Copper Contributor
ADF Power Query with Dynamic Parameter
Hey guys,
I have a blob storage with csv file that will be created hourly under a specific folder with a new file name.
I want to do data wrangling on the file before sinking the data in SQL Azure Table.
Does anyone know how to pass a dynamic Parameter which is the newly created file name in blob and have pass it to Power Query.
I started working on it but I'm stuck.
This is what I have done so far
- I have trigger when file is created
I don't know where to go from here.
Can you guys guide me in the right direction?
I appreciate your help.
John
No RepliesBe the first to reply