Power BI Modify Data Set with security applied before hand

[Anonymous]

I have a use case where the customer is allowed to modify the power BI data set so they can join a custom data source to their existing data and use that in reporting

The issue at the moment is that customer should only be allowed to see their own data whilst modifying the data set unfortunately row level security is applied after this step, is it possible to apply this security beforehand? how would i do this, would building an ssas tabular model with rls before hand apply that security at the level where you modify your power bi data set.

[Anonymous · Accepted solution]

Hi @Anonymous,

It is impossible to dynamic add datasource to existing dataset.(power bi not support dynamic data table structure)

>>The issue at the moment is that customer should only be allowed to see their own data whilst modifying the data set unfortunately row level security is applied after this step, is it possible to apply this security beforehand?

There is no difference between enable it before and after create report.  RLS is setup on datasource, it not effect created visual and reports except table records.(RLS filter is same as query table filter, it enable filter on source table)

RLS with UserName()

Notice: please don't forget assign role on service side to enable RLS effect.

BTW, you can only setup RLS on desktop side, you can't do customize on power service side to create or modify RLS settings except assign role.

Regards,

Xiaoxin Sheng