How to access Cloud MySQL Data with Gateway in Desktop

[Hotkey]

I've the challenge to access data from a MySQL Server in PowerBi Desktop. The corresponding dataset is located in the PowerBi Service.

The MySQL Server is hosted in the cloud.

My approach so far:

• Running Windows Server System also in the cloud
• On Windows Server i've created a SSH-Tunnel to the MySQL Server
• On Windows Server i've installed the MySQL Connector as well as the PowerBi Gateway Software
• In PowerBi Service i've created a gateway/connected to the Gateway and created a MySQL Connection which says "it's working"

Now the challenge: How can i actually access the MySQL Tables as a datasource in PowerBi Desktop? Can i do this directly or do i have to do something else within the service first?

Appreciate any help, thanks in advance!

[v-piga-msft]

Hi @Hotkey ,

Have you solved your problem?

If you have solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

If you still need help, please feel free to ask.

Best  Regards,

Cherry

[v-piga-msft]

Hi @Hotkey ,

Normally, if your data source is online, you don't need to add it to data gateway.

It seems that you have configured the My SQL data source in data gateway in power bi service.

You could connect the data source with My SQL connector in Power BI Desktop.

If you still need help, please feel free to ask.

Best Regards,

Cherry

[Hotkey]

Sorry for the long delay, the notification mail got junked.

---

@v-piga-msft wrote:

Hi @Hotkey ,

Normally, if your data source is online, you don't need to add it to data gateway.

It seems that you have configured the My SQL data source in data gateway in power bi service.

You could connect the data source with My SQL connector in Power BI Desktop.

If you still need help, please feel free to ask.

Best Regards,

Cherry

---

Yes, i have data source online, but on a Linux Server with no remote access to the database allowed (only via SSH Tunnel from localhost). So i can think about creating a tunnel on my Desktop PC and then use the connector to access the data from PowerBi Desktop.

But if i then would publish the Dataset to the service: How does the service then is able to connect to the source? Would it then use the gateway?

Thanks again for help