As the MSSQL Server OLEDB adapter doesn't have an option like NLS_LANG, we have another way to achieve it. One can add 'Language=Spanish' in the field of 'Additional Connection string keywords (optional)', so that all the text coming from the same adapter will be translated into Spanish language.
To set the language as Spanish:
- Navigate to the reporting server
- Go to 'Get Data'
- Double-click on 'MySQL Server OLEDB/AZURE DB Connections'
- Right-click on the connection
- Select 'Properties' you will see the field called 'Additional Connection String Keywords (optional)
- Add LANGUAGE=spanish
Below is the screenshot for reference: