Forum Discussion

chaima's avatar
chaima
New Member
6 years ago

Can't connect gateway to data source

Hi,

 

I have a problem to connect my PBI gateway to a data source I checked around and try a few solutions with no success.

I have 2 servers in the cloud. one is Debian 9 with MySQL database and the other one is windows server 2016. I have installed the gateway on the windows server but when I try to connect to the MySQL database I'm getting an error "we could not register this data source for any gateway instances within this cluster" I was able to connect with ODBC to my PBI desktop that I install on this server so connection can be established.

I tried to connect to SQL server MySQL ODBC. all gave me the same error.

 

Thank you,

Chaima

Need Help

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi chaima ,

     

    I found some topics about the same error message, please see if it helps.

    https://community.powerbi.com/t5/forums/searchpage/tab/message?advanced=false&allow_punctuation=false&filter=location&location=forum-board:power-bi-web-app&q=we%20could%20not%20register%20this%20data%20source

     

    Best Regards,

    Jay

    Community Support Team _ Jay Wang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • chaima's avatar
      chaima
      New Member
      6 years ago

      Hi Anonymous Jay,

       

      Thank you for your reply, I looked in the solutions but it didn't help. here are the error details I get:

      Activity ID:21c1f6bc-19e9-4196-af83-65ff96a3e5ed
      Request ID:b05713d8-359c-ca24-17bb-dea8b618e31a
      Cluster URI:https://wabi-west-europe-b-primary-redirect.analysis.windows.net/
      Status code:400
      Error Code:DMTS_PublishDatasourceToClusterErrorCode
      Time:Thu Jan 30 2020 09:02:24 GMT+0000 (Greenwich Mean Time)
      Service version:13.0.12023.283
      Client version:2001.1.013
      test1:Unable to connect to the data source undefined.
      Underlying error code:-2147467259
      Underlying error message:ODBC: ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
      DM_ErrorDetailNameCode_UnderlyingHResult:-2147467259
      Microsoft.Data.Mashup.ValueError.DataSourceKind:Odbc
      Microsoft.Data.Mashup.ValueError.DataSourcePath:dsn=x
      Microsoft.Data.Mashup.ValueError.OdbcErrors:#table({"SQLState", "NativeError", "Message"}, {})
      Microsoft.Data.Mashup.ValueError.Reason:DataSource.Error
      • Anmolgan's avatar
        Anmolgan
        Icon for Post Prodigy rankPost Prodigy
        6 years ago

        chaima Maybe you can raise a support tickte and troubleshoot the issue, directly with Microsoft.