I want to import some tables from a MYSQL DB. I cannot get direct access to the DB due to security restrictions from the provider. They will only give SSH access, so i believe the MYSWL import function is ruled out?
When in production I want the connection to refresh a couple of times a day. Any ideas what is the best way to get access?
- Set up a job to export the tables as CSV to a FTP-server and download them to a machine and the into Power BI / Excel?
- Do some export of the DB to a new DB in another server, which I can connect to directly from Power Bi /Excel?
- Use this API to push dato into Power BI (Will it only be Power BO online, or can it also be Desktop / Excel?)?