Forum Discussion

Kliment's avatar
Kliment
New Member
5 years ago
Solved

Power BI Online connection with MySQL database, gateway required

Hi Everyone,    old user with a new username here :).   I have a Power BI desktop report which connects to MySQL database on the cloud. I did all modifications and published the report on Power B...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 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.