cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
bstripp Frequent Visitor
Frequent Visitor

DAX function to determine/display a SSAS Role?

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?

1 ACCEPTED SOLUTION

Accepted Solutions
v-ljerr-msft Super Contributor
Super Contributor

Re: DAX function to determine/display a SSAS Role?

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. Smiley Happy

 

Regards

2 REPLIES 2
v-ljerr-msft Super Contributor
Super Contributor

Re: DAX function to determine/display a SSAS Role?

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. Smiley Happy

 

Regards

bstripp Frequent Visitor
Frequent Visitor

Re: DAX function to determine/display a SSAS Role?

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.