Forum Discussion

jaidee's avatar
jaidee
Icon for Helper II rankHelper II
10 years ago

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

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?

 

Need Help

2 Replies

  • konstantinos's avatar
    konstantinos
    Icon for Memorable Member rankMemorable Member
    10 years ago

    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