A colleague approached me with a request to install Power BI for him. As I understand it, this software creates various graphs and reports based on data from the database. In this regard, I have a question. The database to which the user asks to give access (
MySQL) is very sensitive to changes, I cannot allow him to change anything in the database. In this regard, I have a question - how exactly does PowerBi communicate with the database? Does it only execute
SELECT requests or can it write data to the database itself? I understand that all this can be limited using different accounts, I am more interested in how the Power BI communicates with the database
So - do I need to do a separate dump of the database purely for this user or can I give him access to the production database?