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.
DeBIe - Are you bringing all of those multiple SQL databases into a single Power BI dataset? Is this a Direct Query situation?
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/