Forum Discussion
ServiceNow Integration with Power BI
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
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
Hi gemcityzach ,thanks for the quick reply, I'll add further.
Hi Anonymous ,
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
6 Replies
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
Hi gemcityzach ,thanks for the quick reply, I'll add further.
Hi Anonymous ,
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
Check out this video. It is a free method to connect to the database:
Hello Anonymous!
I’d like to propose an alternative solution for you, you might want to try out our app - Power BI Connector for ServiceNow:
- https://store.servicenow.com/sn_appstore_store.do#!/store/application/87a42573879e0110fb5033773cbb35...
- https://www.alphaservesp.com/products/servicenow/power-bi/
Also, feel free to reach out support team at [email protected] if you need any assistance.
- Hey PBI V2,Totally get that manual Excel uploads get old and error-prone.Connecting ServiceNow to Power BI via web services (APIs) is a good move. You can usually pull data for multiple reports from flexible endpoints - no need separate web service for each.Direct DB access isn’t really a thing with ServiceNow, it’s all API-based.You could also try tools like Skyvia to automate syncing ServiceNow data into a place Power BI can read, making updates easier without dealing with APIs.
