Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Currently we are using Power BI with a Live Connection for our reporting.
Row level security is performed via SSAS roles. Visualization is embedded from a Webpage and called with the Microsoft API. So far things are working as expected. However, I am trying to find out how I would display to the user what Role they have withing DAX/PowerBI.
There are the following authentication functions:
USERNAME() - Doesn't work for us since we are using a service account for all calls
CUSTOMDATA() - This could be used, but seems redundant if I already have a role assigned to me
Is there any other way to display which Roles a user to my Page has?
A ROLE() command would be brilliant, but as far as I can tell, doesn't exist.
Thoughts?
Solved! Go to Solution.
Hi @bstripp,
Is there any other way to display which Roles a user to my Page has?
As far as I know, there isn't a way to do it with live connection currently.
A ROLE() command would be brilliant, but as far as I can tell, doesn't exist.
I would suggest you add it as an idea on Power BI Ideas forum to improve Power BI on this feature.
Regards
Hi @bstripp,
Is there any other way to display which Roles a user to my Page has?
As far as I know, there isn't a way to do it with live connection currently.
A ROLE() command would be brilliant, but as far as I can tell, doesn't exist.
I would suggest you add it as an idea on Power BI Ideas forum to improve Power BI on this feature.
Regards
Thanks. I have come to the same conclusion.
I'm having to come up with code to populate the CUSTOMDATA field to pass roles. It's ugly and not an elegant solution, but it's working at the moment. Considering they let us expose both USERNAME and CUSTOMDATA it's a suprise that we can't get the roles that the current user is assigned.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |