Aaah I feel like I'm going a little crazy. So I followed the advice below and donwgraded to an earlier Connector version (8.016 I think) and it cleared this error and I was able to connect fine for a few weeks. I was recently experimenting with another BI tool and needed 8.0.17 so upgraded again. To use PowerBI I downgraded again this week and now whenever I try to connect I just get 'We couldn't authenticate with the credentials provided' message. I've tried 8.0.15, 8.0.16, different user names and passwords and still have the same. Credentials are fine as when I connect via MySQL Workbench it connects okay. Any ideas?
This is so frustrating. I've spoken to PowerBI support and they couldn't help either. Main points:
Trying to connect to MySQL DB secured via SSL
This worked earlier in the year
Something changed (no idea what) and now I get an authenticartion error whenever I click login.
Things I've tried:
Installing versions 8.0.14, .15. 16 .17 and .18 of MySQL Connector
Using another computer
Adding certs to the computer cert store (Personal, Truster Root, Third party)
Removing everything and starting again
To prove it is something to do with the certs I've also asked the DB admin to remove them and this allowed me to connects immediately using username and password only
To prove the certs are okay I can connect to the DB from my maching using MySQL workbench. Interestingly you actully point to the cert pem files in the Workbench login screen. I also spoke to Tableau about this and their support were able to help me connect using the same certs with no issues.