This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(150.4, 89%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELH%3C/text%3E%3C/svg%3E)
How can I create an Excel dataset with a parameter for the filename using a linked service in my Azure Synapse workspace? If I substitute a parameter for the filename, I receive an error when previewing the data in the dataset. The error message shows the correct path, and I can browse to the location and see the file in my Synapse workspace. I am using the default storage created with the workspace. The error I receive is:
ADLS Gen2 operation failed for: Operation returned an invalid status code 'NotFound'. Account: XXXXXXXX FileSystem: 'content'. Path: 'vulnerability/1-vulndocflatimport.xlxs'. ErrorCode: 'PathNotFound'. Message: 'The specified path does not exist.'. RequestId: 'XXXXXXX. TimeStamp: 'Fri, 29 Dec 2023 16:30:58 GMT'.
Operation returned an invalid status code 'NotFound'
I think the firewall is blocking ADF from reading or writing files. Check the solution : https://legacysupport.timextender.com/hc/en-us/articles/360054872132-ADF-execution-error-ADLS-Gen2-operation-failed-for-Operation-returned-an-invalid-status-code-Forbidden-
Hi Lance Harra,
Thank you for posting query in Microsoft Q&A Platform
This error may happen, when we parameterize, folder filed and use file name also in the folder field parameter. Kindly make sure, you have a parameter in dataset separately for file name and use that parameter for file name.
Please check below screenshot for better idea.
Hope this helps. Please let me know if any further queries.
Please consider hitting Accept Answer button. Accepted answers help community as well.
Hi Lance Harra, Thank you for sharing screenshots. I suspect the details filed under Source Options. Could you please share them once to understand more?
This is the source options tab
Hi Lance Harra,
kindly consider having parameter in dataflows and remove file parameter from dataflow. And then under source options, wildcard paths filed, try to have your file path compiled with dynamic expression.
Hope this helps. Please let me know how it goes.
Please consider hitting Accept Answer button. Accepted answers help community as well. Thank you.
I am not sure what changes you want me to make in the dataflow
Here are the changes I made to the dataset.
Here are the changes to the dataflow
This is the error I get when previewing the data.
Hello Lance Harra, Kindly consider pointing your dataset to your container and folder correctly, but don't use any parameters in dataset, and then in the dataflow use parameters for directory and file name under source options. Hope that helps.
Please consider hitting Accept Answer button. Accepted answers help community as well. Thank you.