Power BI Embedded Parameters and Filter - row level security on SSAS Cube

Hi Anonymous,

---

---

Filter in url - like ?filter=<Table>/<Field> eq 'value' - but here there is no security as user can simply change url and see all data

The option that filtering a report with a URL query string parameter only works to Service URL. If you append the query string 

?filter=<Table>/<Field> eq 'value' to the URL generated from iframe via publishing to Web, it won't make any difference to report.

---

Row level security - if I have more than 1000 customers should I create the same number of rules to filter out data?

It depends on how you want to grant access to those customers. After creating different roles in desktop, you can add multiple members to corresponding roles by typing in the email address, or name, of the user, security group or distribution list you want to add. In other words, for those customers have been added to the same role, they can see same data rows.  Also, you can try Username() function to configure Row-Level Security (RLS). However, the limitation you need to be aware of is external sharing is not currently supported with datasets that use RLS. And RLS doesn't work if publishing to web. Reference: Row-level security (RLS) with Power BI

Per my knowledge, the above two options you mentioned might not work in your scenario. To configure Power BI embedded Row Level Security, you could refer to:

how to create custom filters for power bi embedded reports

Row level security with Power BI Embedded

Besides, if you have any concern about Power BI embedded, please post your question on Power BI develop forum so that you can get more professional advice.

Best regards,
Yuliana Gu