Azure data flow not showing / in path to data source

_{Tuesday, March 3, 2020 8:43 PM}

I have a JSON dataset that takes 3 parameters year, month, day to be able locate the correct dataset. 

The parametrized path i'm using is

"year-@{dataset().year}/month-@{dataset().month}/day-@{dataset().day}/filename.json"

When I press "Preview Data" in that dataset's tab it successfully locates and displays the data. However, when using that same dataset in my DataFlow the dataset is not found and I get the following error when attempting to preview the data for this source using the same dataset.

DF-FILE-006 at Source 'sourceFile': Path year-2020month-01day-23filename.json does not resolve to any file(s). Please make sure the file/folder exists and is not hidden.

The forward slashes disappear in the path only when using the dataset in DataFlows.

What would be the correct way to handle paths in datasets and for them to also work in DataFlow?

Do I need to escape slashes in a certain way?

_{Wednesday, March 4, 2020 11:00 PM ✅Answered | 1 vote}

Hello BryO3, 

I am able to repro this and I think that you  are putting expression 

"year-@{dataset().year}/month-@{dataset().month}/day-@{dataset().day}/filename.json"

and in the file textbox 

You should add the exepression

"year-@{dataset().year}/month-@{dataset().month}/day-@{dataset().day}"

in the directory text box and file name in the file name and it will work .

Let me know how it goes 

Thanks Himanshu

_{Thursday, March 5, 2020 9:20 PM}

That fixed my issue. Thank you!