Manage roles in Direct Query

[Marcin]

Hi,

Is it possible to personalize view ( filter ) by username ( mail ) using Direct Query connection to SSAS Tabular ?

I want to create dashboard in my company where every employee can see its own content automatically . First I made it with import where Manage Role is possible, but its very problematic with data from SSAS Tabular.

Thanks!

[Anonymous]

Hi @Marcin,

Can you ensure you use the ssas tabular mode? Current power bi only support use "import mode" and "connect live mode" to connect the ssas database. Live mode not support row level security.

Reference link:

Row-Level Security with Direct Query

Regards,
Xiaoxin Sheng

[Marcin]

Hi,

I am using connect live mode and I am aware that Row Level Security is not available in that mode.

But I just want to ask If there is any other posibility to prepare dashboard or report where filter per user name / mail will work.

Using import I need to write DAX Query to get data set form my SSAS base and tranfer all columns in to one tabel so that all filters would work. Using creator to Import I have to make realtionships again.

I am looking for any advice how to make it in easrier way.

thanks!

Marcin

[Anonymous]

Hi @Marcin,

>>I am looking for any advice how to make it in easrier way.

If you want to find a simple way to work through it, I'd like to suggest you refer to the link which I mentioned. it contain the tutorial about how to use SSDT create the RLS.

In Power BI, when connecting SSAS tabular data source in DIRECT QUERY mode, it will directly take the role security defined within Tabular model. We can't "Manage Roles" for Tabular source in Power BI Desktop. To edit roles and corresponding row filters, you have to do it in either SQL Server Data Tools (SSDT) or SQL Server Management Studio (SSMS). Please refer to tutorial below:

Tutorial: Dynamic row level security with Analysis services tabular model

Regards,

Xiaoxin Sheng