BI online connection to MYSQL database.

[hweaves12]

Looking for a definitive answer here.

I can connect to my on premise MYSql database using the desktop version but after I publish my report I cannot set up a data source through my enterprise gateway so that I can schedule a refresh.

Is this possible at all ?

[v-yuezhe-msft]

@hweaves12,

You are able to add MySQL data source within gateway, and set schedule refresh for your dataset in Power BI Service. What error message do you get in the process?

Regards,

[hweaves12]

I'm now getting the error message.

"Your data source can't be refreshed because the credentials are invalid. Please update your credentials and try again.Your data source can't be queried because the credentials are not provided. Please provide your credentials and try again."

When I try to edit the credentials it just seem to hang.

It prefills the form with my local server name and the database name.

My choices of authentication method are windows or basic.

If I choose windows and put my windows credentials in it just spins.

If I choose basic and put my MySql user details in it just spins.

Im assuming that until I resolve this issue then I wont be able to select my data gateway.

[v-yuezhe-msft]

@hweaves12,

Do you add MySQL data source within on-premises gateway? Make sure that you use the latest version of gateway, and the server name and database name are same as that you use to connect to MySQL in Power BI Desktop.

Regards,

[hweaves12 · Accepted solution]

After 2 days of trying to get this to work its now working!!!

I deleted the dataset , republished it from the desktop but was still getting the same issues.

So I stopped and restarted the on premise gateway , re-added the dataset to the gateway and its now working.

I havent done anything different to what I would normally do, other than restart the gateway????

Dont know why or how its decided to work now , but just thankful its now working.

Many thanks.