AnsweredAssumed Answered

Pi ODBC Connection String & Power BI

Question asked by MitchGarside on Jan 18, 2017
Latest reply on Jan 18, 2017 by MitchGarside

I am currently trying to add the Pi ODBC connector as a data source within Power BI in the data gateway. I can connect to the database fine on the desktop version using a pre-configured connection, but when connecting using the data gateway for online services, I get the following error.

 

From some things I have read, this will be fixed if Integrated Security is set to SSPI, but still no joy, the current connection string I am using is:

 

Driver={PI ODBC Driver};Server=Server_Name;database=Database_Name;Integrated Security=SSPI;

 

Any thoughts would be much appreciated

Outcomes