Explore Courses Blog Tutorials Interview Questions
0 votes
in Azure by (17.6k points)

I created an Azure Data Factory, and I am trying to create a new linked service to use an Azure Blob Storage account. The connection test passes successfully, but with the following error every time I try to link the service I'm greeted:

Cannot read property 'Symbol(Symbol.iterator)' of undefined

I am using Azure Data Factory V2 and the service I am trying to link is a StorageV2 account.
Not quite sure where to go from here, would appreciate any suggestions.
Thank you!

1 Answer

0 votes
by (47.2k points)
edited by

I too go the same issue . It occurred when i was trying to create linked services for Azure Storage or SQL Database. I have tried various browsers, different Azure subscriptions, different client machines, deploying Data Factory and storage accounts in different regions and probably a few other things that I have forgotten now.

In the end, I just gave up on the portal and built PowerShell's linked services that worked just fine.

$resourceGroupName = "<Resource group name>"

$dataFactoryName = "<Data factory name>"

$storageAccountName = "<Azure storage account name>"

$storageAccountKey = "<Azure storage account key>"

## JSON definition of the linked service. 

$storageLinkedServiceDefinition = @"


    "name": "AzureStorageLinkedService",

    "properties": {

        "type": "AzureStorage",

        "typeProperties": {

            "connectionString": {

                "value": "DefaultEndpointsProtocol=https;AccountName=$storageAccountName;AccountKey=$storageAccountKey",

                "type": "SecureString"






## IMPORTANT: stores the JSON definition in a file that will be used by the Set-AzureRmDataFactoryV2LinkedService command. 

$storageLinkedServiceDefinition | Out-File c:\AzureStorageLinkedService.json

## Creates a linked service in the data factory

Set-AzureRmDataFactoryV2LinkedService -DataFactoryName $dataFactoryName -ResourceGroupName $resourceGroupName -Name "AzureStorageLinkedService" -File c:\AzureStorageLinkedService.json

Check out Azure Data Factory Training that enables you to master your skills in Data Factory

Browse Categories