Roles appear empty in .pbix consuming from SSAS

[ovonel]

I have a cube, with several roles:

The roles have some complex DAX that allow for dynamic security.

The .pbix consumes from the ssas:

My question is: how/where can I see the roles? Is it only in SSMS that I can??

Roles appear empty here in the PowerBI Desktop. Why?

[TomMartens · Accepted solution]

Hey @ovonel ,

there is a simple answer, you can not see the definition or the members of roles when connecting to a remote SQL Server Analysis Service Tabular model using Power BI Desktop.
When connecting to SSAS Tabular models, Power BI Desktop must be considered a data visualization tool only, no matter the fact that you can create report based measures.

You can use Tabular Editor to inspect the semantic model and have a look at the roles.

Regards,

Tom

[v-linyulu-msft · Accepted solution]

Thanks for the reply from TomMartens,please allow me to provide another insight:

Hi, @ovonel 

I agree with TomMartens.Based on the information I have gathered, your assumption is correct. When using SSAS as a data source in Power BI Desktop, the Roles appear empty typically because you are using the Live Connection mode. In this mode, Power BI Desktop does not display the role information from SSAS. This is because roles and security settings are managed by SSAS, not Power BI.

Use Model explorer in Power BI - Power BI | Microsoft Learn
 

To view and manage these roles, you need to use SQL Server Management Studio (SSMS). In SSMS, you can view the roles in SSAS and manage their DAX expressions and security settings.

Below are the relevant documentation screenshots:

For details, please refer to:

Row-level security (RLS) with Power BI - Microsoft Fabric | Microsoft Learn

I hope my response is helpful to you.

 
Of course, if you have any new discoveries or questions, please feel free to get in touch with us.
 

Best Regards,

Leroy Lu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[TomMartens · Accepted solution]

Hey @ovonel ,

there is a simple answer, you can not see the definition or the members of roles when connecting to a remote SQL Server Analysis Service Tabular model using Power BI Desktop.
When connecting to SSAS Tabular models, Power BI Desktop must be considered a data visualization tool only, no matter the fact that you can create report based measures.

You can use Tabular Editor to inspect the semantic model and have a look at the roles.

Regards,

Tom