Forum Discussion
MySQL Authentification Error with On Premises Data Gateway
Hi everybody, Very frustrating issue and I can't find the same exact issue anywhere else. I have a MySQL connection which works fine on Desktop, but on PBI Online, when using On premises data...
Hello everyone,
I opened a support ticket and the Microsoft Support Team found a solution to this problem. Here's what we had to do :
- On Power BI Desktop :
- Clear cache and then cleared permission from data source settings.
- refresh and put all the credentials again
- Publish it to the service.
- On the online service :
- Add new datasource to the gateway (with old UI link, so that credentials are not required: https://app.powerbi.com/groups/me/gateways?newManageGatewaysUI=false) and gave same privacy level as power bi desktop.
Online refresh worked fine after that.
Antonio
- On Power BI Desktop :
Long standing issue. MySQL and Microsoft blame each other. We have a dedicated gateway with an ancient version (66.8) solely for MySQL refreshes.
Hi,
Thanks for that answer. So it does work with the ancient version ? Do you know where I can find it ?
Thanks again,
Antonio
There is no version 66.8 in this page...
Send me a private message with your email.