Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

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...
Need Help
  • v-ljerr-msft's avatar
    v-ljerr-msft
    8 years ago

    Hi Anonymous,

    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. :smileyhappy:

     

    Regards

v-ljerr-msft's avatar
v-ljerr-msft
Microsoft Employee
8 years ago

Hi Anonymous,

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. :smileyhappy:

 

Regards

Anonymous's avatar
Anonymous
Not applicable
8 years ago

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.