Forum Discussion
Advocate IVRow level security with Premium embedded with live connection to on premise SSAS tabular????
Hi robrien6,
Based on my research, there should be two alternative options to implement RLS for non AD users with Power BI Embedded currently. :smileyhappy:
- Using CUSTOMDATA and SSAS with Power BI Embedded
- Use Filters to pass a filter key as the user identity and a filter id as role, and manage the roles at report level.
Regards
Microsoft EmployeeHi robrien6,
Based on my research, there should be two alternative options to implement RLS for non AD users with Power BI Embedded currently. :smileyhappy:
- Using CUSTOMDATA and SSAS with Power BI Embedded
- Use Filters to pass a filter key as the user identity and a filter id as role, and manage the roles at report level.
Regards
Advocate IVThe custom data solution looks pretty good!
Is this at all supported? We can't use the filters property as it seems like these can be manipulated in the browser etc to strip them out, which would give end users access to more data than they are allowed.
any probelms using the Customdata() property that you can think of?
Many thanks for you contrib!
- v-ljerr-msft
Hi robrien6,
Is this at all supported? We can't use the filters property as it seems like these can be manipulated in the browser etc to strip them out, which would give end users access to more data than they are allowed.
Adding filter should be supported. Though I am not very familiar with JS, I think there is possibility that the filters could be changed by changing the script in browser as you mentioned.
any probelms using the Customdata() property that you can think of?
It seems to me that it's kindly the same as the normal RLS which filters data at dataset, and it's a safer way to go. :smileyhappy:
Regards