Best Methods to Manage a Common Data Source with Multiple Clients

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?