Forum Discussion
Publish and schedule refresh for ServiceNow changes
Hi all,
Connecting via Service Now REST API url is a solution for this need. You can use web datasource in Power BI desktop to connect to this API.
Following link helps you to create REST API url (version specific, you need to check your servicenow version)
eg: URL for retrieving active change requests will look like this - https://<Server Name>/api/now/change_request?sysparm_query=active=true
This one doesn't need a gateway since you are using cloud version of Service Now.
It may not be a good option if you need to pull more than 10k rows. Usually Service now API has a timeout setting for 10k rows.
If you need to pull more than 10k rows you need to load data in batches which you can do by modifying the power query.
Hi all,
Connecting via Service Now REST API url is a solution for this need. You can use web datasource in Power BI desktop to connect to this API.
Following link helps you to create REST API url (version specific, you need to check your servicenow version)
eg: URL for retrieving active change requests will look like this - https://<Server Name>/api/now/change_request?sysparm_query=active=true
This one doesn't need a gateway since you are using cloud version of Service Now.
It may not be a good option if you need to pull more than 10k rows. Usually Service now API has a timeout setting for 10k rows.
If you need to pull more than 10k rows you need to load data in batches which you can do by modifying the power query.