PowerBI translating my data unasked

[JV90]

I design my reports in PowerBI desktop with language English. I then upload the report to the PowerBI service, which has the Dutch language enabled by my organisation. I have a column which contains the order status in English, so I set a filter on the report to exclude status 'Cancelled'. When I then upload the report to the service it automatically changes the status names to Dutch in my data. So the Data says 'Geannuleerd' (Cancelled in Dutch), but my filter is still looking to exclude 'Cancelled', which means the filter is useless.

Is there a way for me to stop PowerBI from translating my data automatically? 

[v-nuoc-msft · Accepted solution]

Hi @JV90 

Power BI provides localization capabilities to convert the Power BI service interface, including menus, buttons, and messages, to the language of your organization or browser settings.

However, it is important to note that Power BI does not automatically convert data in reports. The data remains unchanged when it is entered or imported into Power BI Desktop or Power BI Services.

Your problem may be related to how the dataset or source system handles localization or language settings.

Try the following to resolve the issue:

Check the language settings of the data source. Ensure that the data source does not automatically convert values based on user locale settings or language settings.

Although Power BI Services language settings primarily affect the interface and not the data, it is a good idea to review these settings.

Supported languages and countries/regions for Power BI - Power BI | Microsoft Learn

Regards,

Nono Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[tharunkumarRTK]

@JV90 
What is the culture in your data model and in the browser that you are using?

[JV90]

The Data model in cosmos is mixed language, as there some addresses and company names from around europe. The browser I am using is chrome in Dutch. These settings are sort of company default, and I want each reader of the report to have the same report regardless of language.

[tharunkumarRTK]

@JV90 
https://learn.microsoft.com/en-us/power-bi/guidance/multiple-language-locale#load-a-report-in-power-...

I asked for the semantic model culture, but not about the database. Anyways,
By default, Power BI considers the bowser language settings and presents the data model metadata accordingly. I would suggest you to change the accept header in the URL as suggested in the above document and check if the browser settings are causing this issue.

If the post helps please give a thumbs up

If it solves your issue, please accept it as the solution to help the other members find it more quickly.

Tharun

[JV90]

I tried this approach, but the translated values are still there, even when I made the page language French the Dutch values were still there. I suspect microsoft is looking at the tenant language instead of the page. But would there be a setting somehwere that disallows PowerBI from translating/converting data without permission?

[tharunkumarRTK]

@JV90 
I dont think either your tenant location or your tenant settings caused this problem. 

If the post helps please give a thumbs up

If it solves your issue, please accept it as the solution to help the other members find it more quickly.

Tharun