question

PraveenKumar-8497 avatar image
0 Votes"
PraveenKumar-8497 asked ShaikMaheer-MSFT commented

How to converts string data to Base64 using azure data factory

How to converts string data to Base64 using data factory

azure-data-factory
· 4
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @PraveenKumar-8497 ,

Following up to check, below provided answer help you. Please Accept Answer and Up-Vote. This will help community. Thank you.

0 Votes 0 ·

Hi @PraveenKumar-8497 ,

Just checking is below provided answer help you. Please Accept Answer and Up-Vote. This will help community. Thank you.

0 Votes 0 ·

Hi @PraveenKumar-8497 ,

Just check is below provided answer helps you. Please Accept Answer so that other community people also get benefit. Thank you

0 Votes 0 ·

Hi @PraveenKumar-8497 ,

Is below provided answer worked for you. Please Accept Answer that helps community as well. Thank you

0 Votes 0 ·

1 Answer

ShaikMaheer-MSFT avatar image
0 Votes"
ShaikMaheer-MSFT answered PraveenKumar-8497 commented

Hi @PraveenKumar-8497 ,

Welcome to Microsoft Q&A Platform. Thank you for posting your query here.


If you would like to convert string value in to base64 in pipeline expression:

Use "base64()" function to do that.
Example: Here, I am converting string data "Hello World" in to base64 format and storing it in to variable.

109068-pipelineexpression.gif

If you would like to convert string value to base64 in dataflow expression:

In below example, I am trying to convert "name" column data to base64 using "toBase64()" function

109040-dataflowexpression.gif

Hope this will help. Thank you


  • Please accept an answer if correct. Original posters help the community find answers faster by identifying the correct answer. Here is how.

  • Want a reminder to come back and check responses? Here is how to subscribe to a email-notifications.



· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi Shaik,

Thank you for your response, could you please confirm, how much data can handle by base64(), I heard from one of the techiee, it could not convert if it has more than 5000 chars.

Thanks
Praveen

0 Votes 0 ·

Hi @PraveenKumar-8497 ,

Thank you for follow up question. Please Accept above Answer if that help you. That will help community.

Regarding data size by base64(), there is no limitation defined as per the documentation. Please check below links for more details.
https://docs.microsoft.com/en-us/azure/data-factory/data-flow-expression-functions#tobase64
https://docs.microsoft.com/en-us/azure/data-factory/control-flow-expression-language-functions#base64

Could you please help me understand, you faced any issues or errors beyond 5000 chars. If yes, it would be great help if you can share error screenshot or details to check further. Thank you

0 Votes 0 ·