USERCULTURE works only for reports implemented with import mode

[giampitz]

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,

@giampitz 

[v-shex-msft]

Hi @giampitz ,

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

[giampitz]

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

[v-shex-msft]

HI @giampitz ,

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

[giampitz · Accepted solution]

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,

@giampitz 

[giampitz]

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,
@giampitz

[venal]

@giampitz 

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