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

Connection Error MySQL OnPrem Gateway

Hi,

 

I am currently working on a dashboarding project and along with SharePoint lists I have been asked to pull data from on-prem MySQL database.  During dev on PBI Desktop, I was able to connect to the MySQL DB and everything seemed alright. Only yesterday I was given the credentials to publish the reports on the company's PBI subscription. I did and in settings section I configured the all the connections for refresh from PBI service.

 

But when I am trying to configure the MySQL source, it doesn't connect. I downloaded and configured the Data Gateway and created a data source for the MySQL db I am using. But some how I am unable to relate this to the dataset, which still is clinging onto the direct credentials I had passed to it while developing it in PBI Desktop.

 

Error1.png

 

This is the gateway setup that I would like to associate with the MySQL source.

Error2.png

 

Help needed to fix the MySQL connect issue, be it using the direct connection or gateway.

2 REPLIES 2
Highlighted
Microsoft
Microsoft

Re: Connection Error MySQL OnPrem Gateway

Hi @Sumit273,

Based on your screenshots, you mix the Power BI personal gateway and on-premises gateway to refresh your dataset. If you want to use on-premises gateway, you don't need to enter credentials for data sources in the first screenshot. Instead, in the second screenshot, please also add SharePoint data source and web data source except MySQL data source under the registered on-premises gateway, then choose “use a data gateway” in the settings your first screenshot shows and set schedule refresh for your dataset. Check that if you can refresh your dataset in this case.

If you want to use personal gateway, you don't need to add data sources of your dataset under the registered on-premises gateway in the second screenshot, just make sure personal gateway service is running properly. You can go to Services, confirm the Data Management Gateway Service is running and make sure that the startup type of the personal gateway service is set to Automatic. Also choose “Basic” authentication type of MySQL in your first screenshot.


Thanks,
Lydia Zhang

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
Solution Sage
Solution Sage

Re: Connection Error MySQL OnPrem Gateway

Hi @v-yuezhe-msft,

 

Your response helped me to configure our mysql credentials to our personal gateway. Glad I read this. Thank you so much!

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

Community Blog

Community Blog

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

Upcoming Events

Upcoming Events

Wondering what events you could join or have an event to promote yourself? Check out our Upcoming Events.

Community Summit Australia – Join Online!

Community Summit Australia – Join Online!

Be a part of the leading Microsoft Business Applications digital event, curated for the APAC community.

Top Solution Authors
Top Kudoed Authors