Forum Discussion

JohnG_PIT's avatar
JohnG_PIT
Copper Contributor
Apr 13, 2024

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 

  1. I have trigger when file is created 
  2.  

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

Resources