does ODBC require gateway?

[Anonymous]

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".

 

[GilbertQ]

I would suggest always going with an ODBC connector, it allows you to configure settings and there is no additional cost to get this working.

[antonstorozhuk]

Hello,

I would like to propose you to try out an alternative option connecting Power BI and Servicenow:

Power BI Connector for ServiceNow app

• https://store.servicenow.com/sn_appstore_store.do#!/store/application/87a42573879e0110fb5033773cbb35...
• https://www.alphaservesp.com/products/servicenow/power-bi/

We have a handy User and Admin Guides for your convenience, but feel free to reach out support team at support@alpha-serve.com if you need any assistance.

Cheers,

Anton

[GilbertQ]

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.