From MYSQL without direct access DB to PowerBI Online / Excel / Power BI Desktop

[jaidee]

Hi

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?)?

And how to do so?

    - https://msdn.microsoft.com/en-us/library/mt147898.aspx

    - https://msdn.microsoft.com/en-us/library/dn877544.aspx  

Any other ideas to setup a strong connection, in the eassiest posible way?

[konstantinos]

I had the same issue..Don't know the exact details as our developer set it up.

The SSH credentials and access was based on Bitvise SSH client

Steps: 

1. Developer set up a connection between our machine ( we used an Azure VM )  and MySQL through Bitvise. 

2. Install Personal gateway in machine.

3. Import Data in PowerBI Desktop ( using ssh credentials & port open from bitvise)

4. Upload pbix to Service and set schedule refresh

Tips..You need to download in machine also the MySQL late net.connector

Also the ssh client need to run with established connection

Hope that helps

[jaidee]

Thanks. How to do step 3