Connection Error MySQL OnPrem Gateway

[Sumit273]

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.

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

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

[Anonymous]

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

[mussaenda]

Hi @Anonymous,

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