Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Lukas_Schli
New Member

PowerBI report for MS List changes language baded on location of user

Hello,

 

I face the following problem:

 

I have an MS List with different columns that all have an English name:

Lukas_Schli_0-1719992331632.png

 

I have now created a PowerBI report on the data in this MS list via "Integrate --> PowerBI --> Visualize this List" option.

Lukas_Schli_1-1719992409420.png

 

 

Everything worked fine but now I'm facing the following problem:

 

Depending on the location of some of the viewers of the MS List / PowerBI Dashboard, the naming of some columns changes.

Affected are e.g. ID, Title and sometimes Date values. Those columns change into the local language and as a result, the charts that use data from those columns are not working any longer.

 

Here, ID changed to Identifykator and Title changed to Tytul.

The language changed to Polish, but I also so Finnish, Spanish, and French in previous cases.

 

Lukas_Schli_2-1719992562773.png

 

As a consequence, I see the following error on visualizations that use the affected columns:

 

Lukas_Schli_3-1719992667407.png

 

My question is: How can I prevent the language change and the related breakdown of reports from happening every time a user from a different location opens the PowerBI report or MS List?

 

Thank you very much for the support.

 

 

 

4 REPLIES 4
Lukas_Schli
New Member

Have not tested it yet due to holidays.

As the report was planned to be a "easy" one just from MS List directly without using PowerBI Desktop, I need to check whether it's worth the effort or whether we would simply "repair" the report everytime it breaks (ie, everytime the language changes).

v-heq-msft
Community Support
Community Support

Hi @Lukas_Schli ,
Based on your description, this is because it's usually due to locales in Power BI, which can automatically adjust the language and formatting based on the user's locale.
To manage this feature, you can use a function in Power BI to dynamically adjust the language and format of the report based on the user's locale: USERCULTURE().
Use locale values in multiple-language Power BI reports - Power BI | Microsoft Learn
powerbi - Dynamically change power bi embedded report based on user - Stack Overflow
Use best practices to localize Power BI reports - Power BI | Microsoft Learn

Best regards,
Albert He

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

Dear Albert,

 

thanks for the proposal. It seems that this requires PowerBI Desktop and goes beyond the capabilities of the PowerBI functionality integrated directly within MS List. I have not yet tried connecting the MS List/SharePoint data to a PowerBI report directly built within the Desktop App. If that is the only option to bypass the language issue, I will take a look at it.

 

Regards,

Lukas

Hi @Lukas_Schli ,

Does the above reply solve your problem. If not, you can follow below.


Best regards,
Albert He


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

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

AugPowerBI_Carousel

Power BI Monthly Update - August 2024

Check out the August 2024 Power BI update to learn about new features.

August Carousel

Fabric Community Update - August 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors