Forum Discussion

agka's avatar
agka
Regular Visitor
9 years ago
Solved

PowerBi RLS with embedded analytics: spaces in username parameter

Hi, everybody! I'm testing Power BI RLS with embedded analytics, and I perform steps from this article: https://powerbi.microsoft.com/ru-ru/documentation/powerbi-developer-embedded-rls/#applying-use...
Need Help
  • yuryb's avatar
    yuryb
    9 years ago

    Hello,

     

    Spaces in the username are not allowed. As a workaround you can replace the spaces in the username for example with underscore ('_') and adjust the role DAX filter accordingly. You can also create a calculated column in the model that contains usernames without spaces.

     

    Best regards

Eric_Zhang's avatar
Eric_Zhang
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

agka

Thanks for reporting that. I can reproduce the same issue when the EffectiveUsername has any space, eg "Effective Username".

 

{   
    "accessLevel": "View",
    "identities": [     
        {      
            "username": "EffectiveUsername",
            "roles": [ "Role1", "Role2" ],
            "datasets": [ "fe0a1aeb-f6a4-4b27-a2d3-b5df3bb28bdc" ]
        }   
    ] 
}

 

 

yuryb

Do you have any comments on this? Is this a limitation or issue?

  • yuryb's avatar
    yuryb
    Icon for Power BI Team rankPower BI Team
    9 years ago

    Hello,

     

    Spaces in the username are not allowed. As a workaround you can replace the spaces in the username for example with underscore ('_') and adjust the role DAX filter accordingly. You can also create a calculated column in the model that contains usernames without spaces.

     

    Best regards

    • agka's avatar
      agka
      Regular Visitor
      9 years ago

      Thanks to everybody! that's helps!