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
