MySQL Scheduled Refresh in Power BI Online Not Working - cannot connect to data Source

[ziggyz]

So I did the following:

1. Created an Azure MySQL database.  Ticked YES to allow public access to any Azure service

2. Uploaded raw data to my Azure MySQL DB using MySQL Workbench

3. Created a Power BI report connecting to the Azure MySQL Db via Power BI Desktop

4. Published the Power BI report online.

5. The Power BI Report online is working.

So I want now to make a scheduled refresh of the report.

But I could not login/sign in. See screenshot..

What do I do?

[vfalmeida · Accepted solution]

@ziggyz after some googling, I discovered that Mysql requires a data gateway. You're going to need to install a data gateway at a machine in the azure cloud https://community.powerbi.com/t5/Service/Mysql-cloud-database-refresh-data/m-p/1457998

[Anonymous]

Hi  @ziggyz ,

Is your problem solved, if it is solved, you can mark the correct answer as a marker, if it is not solved, you can provide detailed information, we can help you better.

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous · Accepted solution]

Hi  @ziggyz ,

Here is the URL to download Gateway:

Install an on-premises data gateway | Microsoft Learn

You can go to Dataset configurations -- Data Source Credentials -- then edit credentials.

This is the related document, you can view this content:

Solved: Re: How to refresh dataset on Power BI Service fro... - Microsoft Power BI Community

Data refresh in Power BI - Power BI | Microsoft Learn

Configure scheduled refresh - Power BI | Microsoft Learn

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[vfalmeida · Accepted solution]

@ziggyz after some googling, I discovered that Mysql requires a data gateway. You're going to need to install a data gateway at a machine in the azure cloud https://community.powerbi.com/t5/Service/Mysql-cloud-database-refresh-data/m-p/1457998

[ziggyz]

where should this data gateway need to be installed?

[Anonymous]

Hi  @ziggyz ,

After you can't log in is there a yellow box, click inside details, copy the error message inside to here, we can help you better.

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[ziggyz]

Hi Liu Yang.

There is no error message coming out. After I try logging in the circle just keeps on moving and I left it for many minutes and nothing happens

[vfalmeida]

I'm having exactly the same problem. Maybe it's a problem with azure?