Forum Discussion
Authentication Error in PowerBI Service MySql server
Hello Comunity,
I have created a dashboard that connects with a MySQL server, the connection and the credentials work as supposed to when working in PowerBI Desktop, however when uploading said dashboard I get this error:
When I try to update the credential in the "Manage connections and gateways" view, I also get the same error:
I have checked the credentials multiple times and they work fine in the PowerBI Desktop app.
I am using MySQL Connector 8.2.0 as it is the only one that works for the Desktop Version
Can someone please help? Is it a PowerBI Service issue or a MySQL server issue?
Thank you!
Thanks solution from GilbertQ
Hi, bhernandezc
Are you using a personal gateway? Currently, MySQL can only be connected through an enterprise gateway(standard mode) or cloud.
Power BI Gateway | Microsoft Power BI
If you're making an error adding your credentials, you can try an alternative solution:
Power Query MySQL database connector - Power Query | Microsoft Learn
How to Get Your Question Answered Quickly
If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .
Best Regards
Jianpeng Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
4 Replies
Hi bhernandezc
And appears to me that based on the. error messages, the credentials you are putting are not 100% the same. Could you first copy and paste the values into notepad and then copy and pasting from notepad into the service and see if that resolves your issue? Also, you might need a gateway to connect to your MySQL server.
I have the same issue, I checked the credentials and nothing seems to work, I think it might be related with the MySQL connector, I'm running version 8.4.0 and can't connect even in the Desktop version, please help!
Thanks solution from GilbertQ
Hi, bhernandezc
Are you using a personal gateway? Currently, MySQL can only be connected through an enterprise gateway(standard mode) or cloud.
Power BI Gateway | Microsoft Power BI
If you're making an error adding your credentials, you can try an alternative solution:
Power Query MySQL database connector - Power Query | Microsoft Learn
How to Get Your Question Answered Quickly
If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .
Best Regards
Jianpeng Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Yes it worked, I had to reset my On-premises gateway, but after that the problem was solved, thank you!
