Power BI to Service Now

riaz_mansuri · ‎11-29-2020

Hi,

We are thinking of using Power BI as a reporting tool from Service Now. What I would like to know is:

1. What is the best way to form the connection between the 2 systems. Does a connector exist?

2. Anyone aware of any licencing restrictions?

3. Can this impact performance on Service Now?

Thanks

Riaz

Ankur Bawiskar · ‎11-29-2020

Hi,

Please find points below:

If you are planning to allow Power BI to fetch ServiceNow data then you can either use OOB table API or Scripted REST API - no license issue here
If you are planning to consume Power BI API and push data from ServiceNow by consuming REST or SOAP message then also there won't be any license issue.

Impact in performance - If Power BI is consuming ServiceNow endpoint like once in every 5mins or less to pull the table data it would lead to impact to the instance. I would suggest to do this in off-business hours.

Refer below links for help

connect ServiceNow and PowerBI via REST API in order to build reports and publish them on PowerBI Se...

How to explore serviceNow Data with Power BI

Show reports in power bi for problem list

Connecting to RestAPI from Excel or PowerBI and getting all fields in security incident to display

Regards
Ankur

Regards,
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader

View solution in original post