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

[BTPowerBIUser]

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

[ibarrau]

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,