ADF - SAP BW via MDX - language option

Question

Hi, I'm reading data from SAP BW, but there is one field that relies on the language of the connection. When I run the query from my computer (language = PT), it works OK But when I run the same query from Azure Data Factoy, the field gets the english translation. It is the same result as running from my computer and changing the language to EN Where do I configure the language?

Answer 1

Hi @Anonymous ,

Welcome to Microsoft Q&A forum and thanks reaching out.
It has not been exposed in UI, but we can set it by editing the linked service JSON payload. To do so please go to SAP BW LinkedService->code-> set language by add the below property in "typeProperties":

"language": "PT"

Please see below GIF for more clarification:

Please make sure to publish the changes before you the linked service.

Hope this helps.

----------

Thank you
Please do consider to click on "Accept Answer" and "Upvote" on the post that helps you, as it can be beneficial to other community members.