Rest API integration with power bi to fetch the data of incident

[Pradeep Thipani]

Hi @anassheikh ,

What are you looking for exactly here?

You can create a scripted rest API for incident table and create a user in user table. Handover API URL and user details to Power BI team, They will pull the data from API and creates report.

Thanks,

Pradeep

[Pooja Limbani]

Hi @anassheikh 

Please see below links :

• https://www.servicenow.com/community/platform-analytics-articles/how-to-set-power-bi-servicenow-inte...
• https://powerbi.microsoft.com/en-us/blog/explore-your-servicenow-data-with-power-bi/

To establish an API-based connection between ServiceNow and Power BI to enable real-time reporting and visualization of incident-related data. Below are the steps and requirements for setting up this integration:

Integration Steps

1. Open Power BI Desktop and navigate to Get Data.
2. Select More, then search for and choose the ServiceNow connector.
3. Click Connect and provide the following details:
   • ServiceNow Instance URL
   • Authentication Credentials (username/password or OAuth token)
   • Any additional parameters required for filtering or access

Once connected, Power BI will begin retrieving data from ServiceNow based on the specified parameters.

Data Requirements

1. Incidents
   Endpoint: GET /api/now/table/incident

2. Tasks
   Endpoint: GET /api/now/table/task

These endpoints will allow us to pull comprehensive data related to Incidents, task assignments, etc.

Help future readers out—mark the answer and close the thread if it helped you!😊