Create API connection for integrate Power BI

Go to solution
Nani nanee
Tera Contributor

‎06-20-2023 04:48 AM

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.

0 Helpfuls
  • 31,212 Views
1 ACCEPTED SOLUTION

Go to solution
Riya Verma
Kilo Sage

‎06-20-2023 05:32 AM

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.
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

23 REPLIES 23

Go to solution
anitha0887
Tera Contributor
In response to Riya Verma

‎03-05-2024 10:36 AM - edited ‎03-06-2024 12:35 PM

Hi @Nani nanee ,

Hi @NomisKeem  
 
 

I have tried to connect servicenow and power bi vi web option in power BI,i got error following error.please someone help me on this.I am implementing integration between servicenow and power BI, pulling all incident from servicenow table to Power Bi . iam using Rest api explorer to generate  REst api"URL" and  using basic credentails iam getting as follows  "We couldn't authenticate with the credentials provided. Please try again.", please can anyone help me on this.

anitha0887_0-1709663778459.png

 

0 Helpfuls

Go to solution
Nani nanee
Tera Contributor
In response to anitha0887

‎03-07-2024 06:42 AM

Hello Anitha, 

 

You need to select the api end point correctly & provide the basic credentials. For my case, my manager in organization gave the cred's.

0 Helpfuls

Go to solution
gaurrohi
Tera Expert
In response to anitha0887

‎03-07-2024 08:56 AM

Hi @anitha0887,

You need to create a web service account in ServiceNow, and then you should use those credentials in the Basic option mentioned in the screenshot.

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

Regards,
Rohit Singh
0 Helpfuls

Go to solution
anitha0887
Tera Contributor
In response to gaurrohi

‎03-07-2024 01:09 PM

 what would means web service account, is it mean outbound rest message  api or any other

0 Helpfuls

Go to solution
gaurrohi
Tera Expert
In response to anitha0887

‎03-16-2024 05:11 AM

Hi @anitha0887,

To integrate ServiceNow data into PowerBI, you can follow the following steps:

  • Create a New Account in ServiceNow: Log in to your ServiceNow instance and create a new account specifically for data extraction purposes. Ensure that this account has the necessary permissions to access the data you require.

  • Retrieve Credentials: After creating the new account, obtain the username and password associated with it. These credentials will be used to authenticate the connection between PowerBI and ServiceNow.

  • Connect PowerBI to ServiceNow: Open PowerBI and navigate to the data source settings. Choose to connect to a new data source and select Web. Input the credentials (username and password) of the newly created account.

  • Specify API Endpoint: In PowerBI, specify the API endpoint for ServiceNow from which you want to extract the data. This endpoint will depend on the specific data you need (e.g., incident table, change_request, etc.).

  • Extract Data: Once the connection is established and the API endpoint is specified, PowerBI will retrieve the data from ServiceNow using the provided credentials and API endpoint. YOu can also enable query and filter in the API.

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

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

Regards,
Rohit Singh