Forum Discussion
Update multiple reports
DeBIe - Maybe something via the Power BI REST API but the best thing to do in your scenario is to use Row Level Security (RLS) and that way you only have a single report to deal with.
Thanks for your reply. Is there a website/article with an explanation of how to do this?
DeBIe - If you are talking about RLS this should do it: https://docs.microsoft.com/en-us/power-bi/admin/service-admin-rls
or this:
https://www.sqlshack.com/introduction-to-row-level-security-in-power-bi/
Hi, thank you for your reply. I understand now how RLS works, and I've started trying to apply it to the dashboard. But I encounter a problem. That problem is that I have to select the columns for which I want to apply RLS. I need to be able to filter based on the SQL-Server of the desired cliënt.
So imagine I have 15 cliënts. All have their own data warehouse on their SQL-Server environment. I use one of the cliënts data to develop the dashboard. Once developed, I would like to apply this to all existing dashboards. I don't see how that is possible with RLS, because I see RLS as filtering for one cliënt, but for several people within the same organization. For example, one RLS applied to the financial guy, one for the sales guy, etc. All from the same organizations. In this case, I have a lot of different cliënts. I didn't find the solution in the links you gave me, but it gives a good explanation of what RLS does.
DeBIe So the way I see this going down if I read everything correctly. When you bring in data from multiple clients, each is its own query. So bring each data in and add a column "Customer" with the customer name if it is not already present. Then, configure 15 RLS rules, one for each customer. The RLS rules will all be similar:
[Customer] = "ABC Customer"
1 role per customer with an RLS rule like above.