Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
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
Thanks. How to do step 3
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
101 | |
49 | |
19 | |
12 | |
11 |