Forum Discussion
Power BI Online connection with MySQL database, gateway required
- Anonymous5 years ago
Hi Kliment ,
The on-premises data gateway acts as a bridge to provide quick and secure data transfer between on-premises data (data that isn't in the cloud) and several Microsoft cloud services.
If you want to connect to mysql you need a data gateway even if it's in cloud. The idea of having a source in cloud is not the only reason for avoiding a data gateway. It dependes on the source if Power Bi will be able to read it. And the connection mode has nothing to do with whether you want to use a gateway. For more details ,please kindly refer to:
https://community.powerbi.com/t5/Service/Mysql-cloud-database-refresh-data/m-p/1457998
Some official documents:
Guidance for deploying a data gateway for Power BI - Power BI | Microsoft Docs
On-premises data gateway architecture | Microsoft Docs
Power BI data sources - Power BI | Microsoft Docs
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Kliment
Yes you are correct in that only Azure cloud data sources are supported.
You will need to install and configuire either the personal or standard gateway to get your dataset to be refreshed?
Do I need a gateway for BigQuery sources too?