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

Prepping for a Fabric certification exam? Join us for a live prep session with exam experts to learn how to pass the exam. Register now.

Reply
Anonymous
Not applicable

USERCULTURE works only for reports implemented with import mode

Hi all,

 

I discovered a strange behavior (bug?) of the USERCULTURE() function. This always works perfectly when I check the output of the function in Power BI Desktop, regardless of whether the report was developed in import or live query mode to SSAS.

After having published the report, the output in Power BI Service is correct only if the report use the import mode. If the report is connected to a Azure SSAS Tabular model, the function always return en-US.

 

Someone of you have the same problem?

 

Thanks,

@Anonymous 

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Feedback of the MS-support: this function is currently not deployed to work in power bi service and is currently planned to be completed sometime in the First Quarter of Next Year, but there is no an specific ETA.

 

The only way to implement the traslations in a PBI Report connected to SSAS is configuring the language of each user in a table and implement the translations in a similar way of the Row Level Security.

 

Thanks,

@Anonymous 

View solution in original post

6 REPLIES 6
Anonymous
Not applicable

Hi @Anonymous ,

According to your description, it seems like your function extracts the USERCULTURE from service/gateway requests instead of your datasource.

What language your power bi service set? What device region/language that you host the gateway? Please provide some detail information to help us clarify your scenario.

Regards,

Xiaoxin Sheng

Anonymous
Not applicable

Hi,

I’m connected to Azure Analysis Services and thus without using a gateway.
When I change the language on the preferences of the power bi service, only for the reports designed with Import mode the userculture function returns the right value. For those that are connected to Azure Analysis Services always return en-US.
For me is a bug.

Thanks.
GIampil
Anonymous
Not applicable

HI @Anonymous ,

I'd like to suggest you open a support ticket on Azure side to get further support for this scenario. (you can ask them to check the backend processing of USERCULTURE function)

Regards,

Xiaoxin Sheng

Anonymous
Not applicable

Feedback of the MS-support: this function is currently not deployed to work in power bi service and is currently planned to be completed sometime in the First Quarter of Next Year, but there is no an specific ETA.

 

The only way to implement the traslations in a PBI Report connected to SSAS is configuring the language of each user in a table and implement the translations in a similar way of the Row Level Security.

 

Thanks,

@Anonymous 

Anonymous
Not applicable

Hi Xiaoxin,

I’ll do that!
I’m also waiting the support for the SSAS translations. We need to distribuite the apps in 12 different languages and we are managing this part through the bookmarks. Not so easy to maintain...
I will update this post after having received the MS support.

Thanks,
@Anonymous
venal
Memorable Member
Memorable Member

@Anonymous 

If possible can you please share few relevant screenshots for better understaning(working and not working screenshots) to reply on it.

Helpful resources

Announcements
PBIApril_Carousel

Power BI Monthly Update - April 2025

Check out the April 2025 Power BI update to learn about new features.

Notebook Gallery Carousel1

NEW! Community Notebooks Gallery

Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.

April2025 Carousel

Fabric Community Update - April 2025

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

Top Solution Authors