I am pulling data from Azure Data Lake Storage. Azure Synapse Analytics has “Storage blob data contributor” access to the data lake. The container and file name I parameterized and shown in the screen shot above. I then attempted to use my parameters in my root location as container name: $container & folder name: $folder. I am getting the following error when I select browse:
The specified container name ‘$container’ contains invalid characters. Refer to container naming rules: https://learn.microsoft.com/rest/api/storageservices/naming-and-referencing-containers–blobs–and-metadata Operation returned an invalid status code ‘BadRequest’ Activity ID: 24acf8b2-7bad-46e4-821c-a0729767f2ff. When I select preview data I get the following error: “Cannot read properties of undefined (reading ‘0’).” The connection between the storage account and synapse is working.