Reply
Regular Visitor
Posts: 19
Registered: ‎04-27-2018

does ODBC require gateway?

I am planning to connect Power BI service to ServiceNow (a cloud source) via ODBC.  (To be sure, the ODBC driver is 64-bit.)  Does this connection "source" require a gateway?  And, does it matter which connection method (i.e.,scheduled refresh / import / dataset vs live / DirectQuery) I use?  (I would test this myself, but I don't have the ODBC driver available to me yet.)

 

I may have found the answer already here, but I am not sure how to read the "List of available data source types" section  That is, I'm not sure if it's saying that "ODBC connections are only supported for scheduled refresh / import / dataset", or if it's saying that "gateways are only supported for ODBC connections in scheduled refresh / import / dataset mode".

 

Super User
Posts: 3,073
Registered: ‎06-24-2015

Re: does ODBC require gateway?

Hi there

You would require a Gateway to refresh via ODBC. As per the article you would need to have the ODBC connection enabled and configured on the Gateway so that when the refresh happens it can connect to the ODBC source.
Did I answer your question? Mark my post as a solution!
"Proud to be a Datanaut!"