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 - 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 understand that I can enable RLS and set up access rights for multiple users for the same dataset. But is this also possible with multiple customer environments (multiple SQL-databases)?
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.