Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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 re...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    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's avatar
Anonymous
Not applicable
6 years ago

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's avatar
Anonymous
Not applicable
6 years ago
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's avatar
    Anonymous
    Not applicable
    6 years ago

    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's avatar
      Anonymous
      Not applicable
      6 years ago
      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
    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      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