Forum Discussion
ServiceNow
Hi uasarkar, You can try the link below, although it mainly describes the pagination of the query, It has helped me to connect power bi and service now.
https://community.powerbi.com/t5/Desktop/how-to-create-a-query-that-paginates/td-p/20047
uasarkar ,
You can use ODBC connector in desktop and add the service now data source to DSN, for more details, please refer to: https://www.cdata.com/kb/tech/servicenow-odbc-power-bi.rst
Do whitelist the port in firewall rules which is necessary and configure the gateway.
Regards,
Jimmy Tao
Hi, I also have same requirement, and i used ServiceNow ODBC but its showing below error while connecting.
Details: "ODBC: ERROR [HY000] [SN][ODBC ServiceNow driver][OpenAccess SDK SQL Engine]Cannot create schema.Cannot retrieve a DB schema. Please run <instance>?SCHEMA in your browser and try again. Also make sure that the table descriptor cache can hold all your tables and DB views. You can check the table descriptor stats runing <instance>/xmlstats.do in your browser.[1050]"
Request for your assistance.
Also, is there also way to connect via API. If yes, how.