Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi everybody,
I am getting an error while connecting to mySql database
Here is the full error message I see when I refresh the power BI desktop report.
"MySQL: Authentication to host 'xxx.xxx.xxx.xxx' for user '' using method 'mysql_native_password' failed with message: Plugin 'unix_socket' is not loaded".
I would appreceiate any help in this regard.
Thank you.
Solved! Go to Solution.
Thank you Ibendlin for your response. This problem was resolved as follow.
Context of the problem: I changed my lapptop and after installing the power BI on new laptop I did face this problem.
Later I came to know that, when we install power BI, credentials in the Data Source Setting are set to windows by default. So I changed them to Database by going to
Home => Transform data => Data Source Setting => Edit Permissions => Edit => Database and then provide your database credentials there, hit the SAVE button and you are DONE!
Thank you Ibendlin for your response. This problem was resolved as follow.
Context of the problem: I changed my lapptop and after installing the power BI on new laptop I did face this problem.
Later I came to know that, when we install power BI, credentials in the Data Source Setting are set to windows by default. So I changed them to Database by going to
Home => Transform data => Data Source Setting => Edit Permissions => Edit => Database and then provide your database credentials there, hit the SAVE button and you are DONE!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
94 | |
77 | |
65 | |
53 |
User | Count |
---|---|
145 | |
105 | |
104 | |
90 | |
63 |