Forum Discussion
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 BI Online service.
Now, i am trying to do the data refresh, but it fails. Power BI Online doesn't want to connect to MySQL server on the cloud.
Instead it requires a personal gateway so it can connect to my laptop and refresh the dataset. Data Source credentials are greyed out.
I have read somewhere that only Azure databases are supported for this refresh. The desktop report works perfect.
Is this true?
Can someone help me? Below are the screenshots.
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.
5 Replies
Hi Gilbert,
thanks for your response. Does this also apply for DirectQuery?
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.- vincent_nox
Advocate I
Do I need a gateway for BigQuery sources too?
