The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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?
Solved! Go to 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.
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.
@JV90
What is the culture in your data model and in the browser that you are using?
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.
@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
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?
@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
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
51 | |
42 | |
24 | |
23 | |
22 |