cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

BI online connection to MYSQL database.

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 ?

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Frequent Visitor

Re: BI online connection to MYSQL database.

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.

 

View solution in original post

4 REPLIES 4
Highlighted
Microsoft
Microsoft

Re: BI online connection to MYSQL database.

@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,

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Frequent Visitor

Re: BI online connection to MYSQL database.

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.

 

 

Highlighted
Microsoft
Microsoft

Re: BI online connection to MYSQL database.

@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,

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Frequent Visitor

Re: BI online connection to MYSQL database.

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.

 

View solution in original post

Helpful resources

Announcements
Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Power Platform 2020 release wave 2 plan

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021