Refresh the table

[vmjan02]

I have this queries and not sure as why I have to change the file name manually, as looking for the solution so that it will pick the lasted file from the folder by itself.


I have mention the folder path

In this step i have to change the file name, which should not be the case.

step name FreshdataUpload

= Csv.Document(File.Contents("D:\PowerBI_Automation\Ookal_Mean_DailyReport\Daily_RawData_Mean\isp_daily_aggs_2024-09-11.csv"),[Delimiter=",", Columns=26, Encoding=1252, QuoteStyle=QuoteStyle.None])

any way to fix it so that it will get the file name by itself and no need to do any manually changes to file name (isp_daily_aggs_2024-09-11.csv)

 

[vmjan02]

any way on to fix this

 

[JEC]

You are referring to a file and not a folder

 

[vmjan02]

You are referring to a file and not a folder

ok, how to fix this as i tried a lot but no luck