combine report from different languages

Question

Hi ,&nbsp;&nbsp;I have report from different excel files. They have exacty same structure , just diffrerent language English, French, Spanish ( sheet name, column name, column content)&nbsp;How can i load all the files into Power BI and translate (replace Value ) into English ?&nbsp;&nbsp;&nbsp;&nbsp;thank you

parry2k · Answer

ktt777&nbsp;I don't think there is an inbuilt function to convert data from language a to b. I believe you have to it outside Power BI and then import the files.&nbsp;

zaza · Answer

As&nbsp;parry2k&nbsp;mentioned there is no way to do this in PowerBI.&nbsp;Your easiest solution might be to upload your files to google sheets and use the built in googletranslate function.https://support.google.com/docs/answer/3093331?hl=en&nbsp;

v-lid-msft · Answer

Hi&nbsp;ktt777&nbsp;,
&nbsp;
We can also call a Translator Restful API(provided by other cloud provider, such as azure, google, etc..),&nbsp; in AddColumn or ReplaceValue, please refer to following threads about how to use Web.Contents to call a api:
&nbsp;
https://community.powerbi.com/t5/Developer/Easiest-way-of-connecting-Power-BI-to-a-REST-API-with-Oath2/td-p/878735
&nbsp;
Best regards,
&nbsp;

Forum Discussion

combine report from different languages

3 Replies

Related content

Tables combine

Combining Data from Different Semantic Models

M Language Transformations

Combining files from sharepoint with slightly different layouts

Changing Your Community Language Preferences