Forum Discussion

NitzanAroesty46's avatar
NitzanAroesty46
New Member
3 years ago

Problem with my gateway connection on windows VM

Unable to update connection credentials. Unable to connect to the data source. Either the data source is inaccessible, a connection timeout occurred, or the data source credentials are invalid. Please verify the data source configuration and contact a data source administrator to troubleshoot this issue.

Details: Spot_Data_VM: We were unable to find a database provider with invariant name 'MySql.Data.MySqlClient'. Please have this information handy if you choose to create a support ticket.
 
In my laptop the gatewqy work well, but when I installed a new on my windows VM. I got this massage!
and I checked all the connections, my mysql workbech can connect to the database throw the VM...
 
Someone knows how to help me please?
"Power BI Report Server"
Data Gateway Server issue
MySql Data Gateway

1 Reply

  • sergej_og's avatar
    sergej_og
    Icon for Super User rankSuper User
    3 years ago

    I guess you will need an MySQL driver to access your DB from VM.
    Install suitable driver (maybe same version like your local machine) on your VM...probably you will need set up an ODBC connection to your DB.
    Try first to install a suitable driver on VM.

    Regards