cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jaidee Regular Visitor
Regular Visitor

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?

 

2 REPLIES 2
konstantinos Senior Member
Senior Member

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

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

 

Konstantinos Ioannou
jaidee Regular Visitor
Regular Visitor

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

Thanks. How to do step 3

Helpful resources

Announcements
New Ranks and Rank Icons in 2020

New Ranks and Rank Icons in 2020

Read the announcement for more information!

New Kudos Given Badges Coming

New Kudos Given Badges Coming

We're rolling out new Kudos Given badges. Find out how many Kudos you've given.

November 2019 Community Highlights

November 2019 Community Highlights

Get an overview of the events and great community content from November.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Solution Authors
Top Kudoed Authors (Last 30 Days)