I'm trying to connect Power Bi with Mysql Database. I read Power Bi provides a MySQL connector to connect with the server where the database is hosted. I have concerns regarding the security of this connection
Is it secure to let the connector access the entire database?.
Is it possible that it can access only the concerned tables and not the whole database?
How secure is it to expose our database to power bi?