The input is not a valid Base-64 string as it contains a non-base 64 character

Question

The input is not a valid Base-64 string as it contains a non-base 64 character

Oleg Serdyuk 5

The goal is to read data from azure sql db and load it into Azure Data Lake Storage Gen2.

I created parametrized Linked Service that connects to ADLS gen2. Supplied URL and Access Key - test connection works fine.

After that I created CSV dataset and used Previously created linked service. Test connection - works fine.

However, when executing Copy Activity it gives me an error saying that supplied account key is invalid.

I go back and check connection with Linked Service and DataSet - both works fine.

So what am I missing?

User's image

Andriy Bilous 11,821 Reputation points MVP Volunteer Moderator

2023-08-31T20:55:03.7466667+00:00
Hello @Oleg Serdyuk

I understand that your ADF is able to go into the key vault and read the secret value but probably it is not able to identify it as a Base-64 string.

I suggest to do the following steps:

Verify the storage key.

Check the configuration of the ADF.

Check how you defined your variable.

Try putting your storage account connection string within double quotes.

Some other helpful links:

https://stackoverflow.com/questions/15114044/the-input-is-not-a-valid-base-64-string-as-it-contains-a-non-base-64-character

https://techcommunity.microsoft.com/t5/azure-data-factory/linked-service-adls-gen2-via-key-vault-error-the-specified/m-p/1490824
KranthiPakala-MSFT 46,642 Reputation points Microsoft Employee Moderator

2023-08-31T23:10:32.59+00:00

@Oleg Serdyuk Thanks for using Microsoft Q&A forum and posting your query.

You have mentioned parameterized linked service. Could you please help share the linked service JSON Payload to get an understanding of how it is configured? Did you also parameterize Account Key as well?

You mentioned that the dataset and linked service connection works fine. COuld you please confirm if you were able to preview the data from dataset?
KranthiPakala-MSFT 46,642 Reputation points Microsoft Employee Moderator

2023-09-01T21:31:22.3966667+00:00

@Oleg Serdyuk checking to see if you have got a chance to see my previous comment, if so kindly share requested details so that we can assist accordingly.

Thank you

Your answer

Andriy Bilous 11,821 Reputation points MVP Volunteer Moderator

2023-08-31T20:55:03.7466667+00:00

Hello @Oleg Serdyuk

I understand that your ADF is able to go into the key vault and read the secret value but probably it is not able to identify it as a Base-64 string.

I suggest to do the following steps:

Verify the storage key.

Check the configuration of the ADF.

Check how you defined your variable.

Try putting your storage account connection string within double quotes.

Some other helpful links:

https://stackoverflow.com/questions/15114044/the-input-is-not-a-valid-base-64-string-as-it-contains-a-non-base-64-character

https://techcommunity.microsoft.com/t5/azure-data-factory/linked-service-adls-gen2-via-key-vault-error-the-specified/m-p/1490824
KranthiPakala-MSFT 46,642 Reputation points Microsoft Employee Moderator

2023-08-31T23:10:32.59+00:00

@Oleg Serdyuk Thanks for using Microsoft Q&A forum and posting your query.

You have mentioned parameterized linked service. Could you please help share the linked service JSON Payload to get an understanding of how it is configured? Did you also parameterize Account Key as well?

You mentioned that the dataset and linked service connection works fine. COuld you please confirm if you were able to preview the data from dataset?
KranthiPakala-MSFT 46,642 Reputation points Microsoft Employee Moderator

2023-09-01T21:31:22.3966667+00:00

@Oleg Serdyuk checking to see if you have got a chance to see my previous comment, if so kindly share requested details so that we can assist accordingly.

Thank you

Share via

The input is not a valid Base-64 string as it contains a non-base 64 character

Your answer