Forum Discussion

BTPowerBIUser's avatar
BTPowerBIUser
New Member
3 years ago

How to refresh data from standalone mysql database in app.powerbi.com(Web services) without gateways

Hi,

 

We have a strange requirement where we have to connect directly to standalone mysql database installed in our on-premises server for scheduled refresh from app.powerbi.com (web services) without any personal gateways (In Desktop or any other Personal Devices)

 

Need your support to resolve this challenge

Need Help

1 Reply

  • ibarrau's avatar
    ibarrau
    Icon for Super User rankSuper User
    3 years ago

    Hi. I'm sorry but in order to connect to a mysql database you must install a gateway. You can read more about it here: https://learn.microsoft.com/en-us/power-query/connectors/mysql-database#prerequisites

    By default that's the only way.

    An approach would be developing something outside PowerBi. There are some companies that have APIs to get data from databases. If you develop something like that, the connector for power bi would be a Web one that won't require a gateway. Of course this is a lot more working hours.

    I hope that helps,