Forum Discussion

gcosta94's avatar
gcosta94
Frequent Visitor
2 years ago
Solved

ODBC Connection String for ElasticSearch

Hi everyone

 

I'm struggling to establish a connection to my ElasticSearch data source on Power BI Online.

 

On the desktop I've successfully connected to the source via the ODBC connector, as I've previously set up the ODBC on my computer.

 

I've then installed a personal gateway and published my report to PowerBI Online. However, when setting up the connections on the datasource, I've come to this:

 

I've tried the regular credentials but the main issue is that the connection string doesn't seem to be found. I've looked on the ODBC data source admin to see if there's any connection string, but there isn't. Also I didn't pass any to PowerBI desktop, only the configured dsn


Does anyone know how to get this connection string?

 

 

 

 

  • did you set the dsn up as a user dsn or a system dsn ?  (Hint:  Needs to be a system dsn)

4 Replies

  • did you set the dsn up as a user dsn or a system dsn ?  (Hint:  Needs to be a system dsn)

    • gcosta94's avatar
      gcosta94
      Frequent Visitor

      It was a user dsn and now I succeed to connect on system dsn. What should I do next?

      • lbendlin's avatar
        lbendlin
        Super User

        repeat the same setup on all gateway cluster members.