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 t...
Need Help
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.

      • chaima's avatar
        chaima
        New Member
        6 years ago

        Already did. they escalate it to the dev team.

        I was able to connect the power bi with personal getaway but not with the enterprise gateway.

        Hope to hear from the support soon.

         

        Thank you.