Create API connection for integrate Power BI

Nani nanee · ‎06-20-2023

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 · ‎06-20-2023

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:

Open the Power BI application and navigate to the "Get Data" option.
Select "More" and search for "ServiceNow" in the available connectors.
Choose the ServiceNow connector and click on "Connect."
Provide the necessary details such as the ServiceNow instance URL, authentication credentials, and any additional parameters required for the connection.
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:

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

Please mark the appropriate response as correct answer and helpful, This may help other community users to follow correct solution.
Regards,
Riya Verma

View solution in original post

gaurrohi · ‎02-21-2024

Hi @AMercier ,

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.

Please let me know if it helps.

Please mark the response as the correct answer and helpful. This may help other community users to follow the correct solution.

Regards,
Rohit Singh

ALennox · ‎02-28-2024

What URL should you use to get the data into PowerBI using the Web data retrieval option?

gaurrohi · ‎02-29-2024

Hi @ALennox

You'll need to call the table API from Power BI. For example, for Incident Records, use the following format: https://<your-instance>.service-now.com/api/now/table/incident

Additional parameters can be added to the URI as needed. Remember to provide the credentials based on the selected authentication. You can also use REST API Explorer in ServiceNow to explore and add the parameters and methods as per your requirements.

Please mark the response as the correct answer and helpful. This may help other community users to follow the correct solution.

Regards,
Rohit Singh

anitha0887 · ‎03-05-2024

Hi @gaurrohi

Hi @Erik Gunther2

Hi @R34rvi3w

Hi @Nickels

Folks help me on this.

iam able to connected successfully, not able to pulling data from incident table into power Bi.I used following servicenow url:https://company name service-now.com/incident.do , however when i used following url :https://company name service-now.com/api/now/table/incident --not able connected to power BI.Please someone help me on this.

anitha0887 · ‎03-04-2024

Hi @Riya Verma , on servicenow side ---- can we use outbound integration--rest Message API right