Best Methods to Manage a Common Data Source with Multiple Clients

[Bebo]

I currently have a master database in MySQL which collects data from several locations throughout the country. This data is logged by date/time and location. My question is what is the most efficient and reliable method to provide access to a common set of Power BI reports / visuals (developed in Power BI Desktop) to multiple clients so that they can only view their specific data that would be based on their location in the common MySQL database? 

[Greg_Deckler · Accepted solution]

@Bebo Well, the general answer is Row Level Security (RLS).