Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

How to access Cloud MySQL Data with Gateway in Desktop

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: ...
Need Help
v-piga-msft's avatar
v-piga-msft
Resident Rockstar
7 years ago

Hi Anonymous ,

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

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

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

     

    v-piga-msft wrote:

    Hi Anonymous ,

    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