Forum Discussion
Powerbi Gateway MYSQL Datasource Error
Hi lbendlin
Thank you for your response and consideration - As stated in the original post:
I have tried clearing the Permissions from the workbook and global settings - this then requires me to re enter the credentials, which I do, and then after a moment, it comes up saying cannot connect through encrypted connection, do I want to try connect through unencrypted connection to which I click okay. I then get the following error on PBI - MySQL: Authentication to host '**.**.***.**' for user 'U******' using method 'mysql_native_password' failed with message: Reading from the stream has failed.
Also, to add, the exact same report will run (refresh) on a different non-domain joined device with a PowerBI Pro licence.
Similarly, nothing has changed on the settings side for us - and this report previously refreshed up to early February without fail.
So I am still at a loss as to what could be going wrong.
Have you considered using the native MySQL or MariaDB driver rather than ODBC ?
Thanks for your input.
Please could you elaborate further on what you're suggesting?
The server we are connecting to is a vendor provided server. Previously the ODBC connection worked, however, Im not sure what your suggestion entails.
Should I install the MariaDB ODBC driver on the PBI Gateway? or Test it on my PC?
Thank you.