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

Khrystyna Shpar · ‎06-23-2023

Hi!

If you ever come to considering alternative options to integrate Service Now and Power BI, feel free the try our newest app - Power BI Connector, it is available from ServiceNow Store.

Khrystyna

Nani nanee · ‎02-09-2024

Thank you @Riya Verma this is absolutely what I have done and worked fine.. Sorry for the late response..

anitha0887 · ‎02-19-2024

Hi Nani,

@Nani nanee , I got same requirement, how did you achieve this requirement.please can you reply .

wobloz · ‎06-26-2024

I believe that you should not connect a BI tool directly to a production system. The best practice is to have an up-to-date reporting database and use this read replica as a Power BI source. You can use tools such as SnowMirror to build such a mirror DB.