Create API connection for integrate Power BI

[Nani nanee]

Hi,

I have a requirement that client is asking to create an API connection for integrate Power BI.

Need to pull all the data, requests, including the task on it, and variables, so they could be ingested by Power BI.

Please reply to this on how to achieve this. Thanks in advance.

[Riya Verma · Accepted solution]

Hi @Nani nanee ,

Hope you are doing great.

create an API connection between ServiceNow and Power BI. This can be done by following these steps:

1. Open the Power BI application and navigate to the "Get Data" option.
2. Select "More" and search for "ServiceNow" in the available connectors.
3. Choose the ServiceNow connector and click on "Connect."
4. Provide the necessary details such as the ServiceNow instance URL, authentication credentials, and any additional parameters required for the connection.
5. Once the connection is established, Power BI will retrieve the data from ServiceNow using the specified parameters.

Next, we need to define the data that needs to be pulled from ServiceNow and ingested into Power BI. T

o retrieve all the data related to requests, tasks, and variables, you can use the following API endpoints:

1. To fetch requests: GET /api/now/table/incident
2. To fetch tasks: GET /api/now/table/task
3. To fetch variables: GET /api/now/table/variable
4. Once you have the data, you can transform and visualize it in Power BI using its built-in data modeling and visualization capabilities.

[AMercier]

Hello @Riya Verma 

I'm attempting to follow your instructions as I've got a similar project for connecting PowerBI to ServiceNow. From what I can see in the PBI Desktop App, ServiceNow is not a certified connector listed under Get Data. Is there a custom connector this is referencing?

[Jeevan Dumpa]

Hi, is there a solution for this. I have the same issue with not being able to find servicenow connector in POWER BI.

thanks

[gaurrohi]

Hi @Jeevan Dumpa,

If ServiceNow is not listed as an option in Power BI's connector list, you can use the web data retrieval option to get data from ServiceNow into Power BI.