Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
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-...
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?
Solved! Go to Solution.
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
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" ] } ] }
Do you have any comments on this? Is this a limitation or issue?
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
Thanks to everybody! that's helps!
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
4 | |
3 | |
3 | |
3 | |
3 |