Forum Discussion
Power BI Modify Data Set with security applied before hand
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)
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
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)
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