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.
I've tried to draw this in paint lol. Hopefully, this makes it clear what I'm looking for?
DeBIe - Right, what I am talking about is creating a single Power BI dataset that includes ALL of the SQL databases for ALL of the customers. You then apply RLS to that so that each customer only sees their own data.
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.