Power BI Online connection with MySQL database, gateway required

[Kliment]

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.

[GilbertQ · Accepted solution]

Hi @Kliment 

Yes the same applies.

[Anonymous · Accepted solution]

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.

[Kliment]

Hi Gilbert,

thanks for your response. Does this also apply for DirectQuery? 

[GilbertQ · Accepted solution]

Hi @Kliment 

Yes the same applies.

[GilbertQ]

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?

[vincent_nox]

Do I need a gateway for BigQuery sources too?