topic Re: PowerBi RLS with embedded analytics: spaces in username parameter in Developer

PowerBi RLS with embedded analytics: spaces in username parameter

agka — Mon, 21 Aug 2017 12:50:18 GMT

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-user-and-role-to-an-embed-token

However I stuck on generating embed token, as I always get error code Bad request with message "Invalid effective username provided"

var generateTokenRequestParameters = new GenerateTokenRequest(
                    accessLevel: "view",                   
                    identities: new List<EffectiveIdentity> {
                        new EffectiveIdentity(username: "Andrey Ma", roles: new List<string> { "Manager" },
                        datasets: new List<string> { "3c1a920e-8389-44a7-8375-c179bb3b0fb2" }
                        )});
var tokenResponse = await client.Reports.GenerateTokenInGroupAsync(groupId, "f8288d00-81fb-4ffb-bd2f-c842079039f5", generateTokenRequestParameters);

I created report with RLS from Retail Analysis Sample

One interesting thing to notice, when I pass value of username without spaces, token generated successfully and report with RLS works normally. So, how I should work with values with spaces?

Re: PowerBi RLS with embedded analytics: spaces in username parameter

Eric_Zhang — Tue, 22 Aug 2017 06:26:57 GMT

@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?

Re: PowerBi RLS with embedded analytics: spaces in username parameter

yuryb — Tue, 22 Aug 2017 07:08:12 GMT

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

Re: PowerBi RLS with embedded analytics: spaces in username parameter

agka — Tue, 22 Aug 2017 08:01:04 GMT

Thanks to everybody! that's helps!