ServiceNow Integration with Power BI

[PBI_V2]

Hello All,

We have a requirement to fully integrate ServiceNow with Power BI so that we can directly connect to ServiceNow using Power BI, & extract data & do reporting in Power BI.

Current Scanario: We downlaod the Incident, Service Request, Change Request & ticketing data from Service Now to Excel and upload it into sharepoint as manual process on daily basis. Power BI consume these excel(s) & we do the reporting. Downloaidng & uploading multiple files everyday is time consuming and prone to errors leading to potential inaccuraccies in data.

To Be Solution: We would like to streamline the process by directly connecting the serviceNow to Power BI to get Incident, Service Request, Change Request & Tickets data for our reporting in Power BI. We have heard that we can create Webservice in ServiceNow and same can be consumed in Power BI. Kindly suggest other approach also if any.

Additional question: 
1) We have around 12-15 reports for which we pull data from ServiceNow so do we need to create separate web service for each report
2) Database Access: Is there any way where we can connect to ServiceNow database and get the data directly.

Thanks,

PBI V2

[gemcityzach · Accepted solution]

From what I know about ServiceNow there should already be an OData feed or some kind of API you can connect to  directly from PowerBI. Based on the article below it looks like you need to have some kind of REST provisioned to your role when accessing.

Explore your ServiceNow® Data with Power BI | Microsoft Power BI Blog | Microsoft Power BI

[v-zhouwen-msft · Accepted solution]

Hi @gemcityzach ,thanks for the quick reply, I'll add further.

Hi @PBI_V2 ,

The following article may be helpful. Install the ODBC driver to the virtual machine hosting the gateway and Power BI Desktop.Then add the ODBC datasource to the gateway, whitelist the IP address of the gateway machine, and add the required ports to the firewall rules.

Solved: PowerBI connection with ServiceNow - Microsoft Fabric Community

[Syndicate_Admin]

Check out this video. It is a free method to connect to the database:

https://youtu.be/vz2iHuhTAXM?si=WrGlDLoOR5Drs966

[Pbidev342 · Accepted solution]

This solution helped us:

https://youtu.be/vz2iHuhTAXM?si=ZjC_LMJCC9JV672V

[v-zhouwen-msft · Accepted solution]

Hi @gemcityzach ,thanks for the quick reply, I'll add further.

Hi @PBI_V2 ,

The following article may be helpful. Install the ODBC driver to the virtual machine hosting the gateway and Power BI Desktop.Then add the ODBC datasource to the gateway, whitelist the IP address of the gateway machine, and add the required ports to the firewall rules.

Solved: PowerBI connection with ServiceNow - Microsoft Fabric Community

[gemcityzach · Accepted solution]

From what I know about ServiceNow there should already be an OData feed or some kind of API you can connect to  directly from PowerBI. Based on the article below it looks like you need to have some kind of REST provisioned to your role when accessing.

Explore your ServiceNow® Data with Power BI | Microsoft Power BI Blog | Microsoft Power BI