Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Service Now ODBC or Rest APIs

Greetings all, I am very new to PowerBi and how to retrieve data that PowerBi doesnt provide out of the box 🙂 

 

My goal is to use PoweBi to retrieve data from ServiceNow.  I have been able to use the ODBC connector and retrieve tables but the one that I am having issues with is retrieving from is the INCIDENT table. It seems to be very large and take a long time to retrieve. What is another method to retrieve data from this table? I am very new to PowerBi, and do not have any experience with RESTApis and other advanced methoids but am very willing to learn. Can anyone please assist me and or point me in the right direction starting at a new user understanding please? 

 

I have found that there are multiple ways to get data from ServiceNow

 

ODBC Connector: Currently able to pull in small tables and works 100%

https://docs.servicenow.com/bundle/orlando-application-development/page/integrate/odbc-driver/task/t_DownloadAndInstallTheODBCDriver.html

 

A RESTAPI: dont understand how to use this 

(https://docs.servicenow.com/bundle/orlando-application-development/page/integrate/inbound-rest/concept/c_ServiceCatalogAPI.html#c_ServiceCatalogAPI

4 Replies