Connecting Power BI to Servicenow

[justingraff88]

Wondering how others are connecting to Servicenow for reporting. We have run into the row limitation through the API and everything else we have found seems to be a paid connector. Found some other articles referencing a Power BI Content Pack but have not been able to find it. Just curious what others are doing?

[Anonymous]

Hello @justingraff88!

I’d like to propose an alternative solution for you, you might want to try out our app - Power BI Connector for ServiceNow:

• https://store.servicenow.com/sn_appstore_store.do#!/store/application/87a42573879e0110fb5033773cbb35...
• https://www.alphaservesp.com/products/servicenow/power-bi/

Feel free to reach out support team at support@alpha-serve.com  if you need any assistance.

[Pbidev342]

There's a free way to connect:

https://youtu.be/vz2iHuhTAXM?si=ZjC_LMJCC9JV672V

[richardc1]

Offset is your friend:
https://Instance

.service-now.com/api/now/table/task_sla?sysparm_query=stage=completed^end_timeRELATIVEGT@month@ago@14&sysparm_display_value=True&sysparm_exclude_reference_link=True&sysparm_fields=sla%2Cend_time%2Csys_created_on%2Cstage%2Cend_time%2Chas_breached%2Ctask&sysparm_limit=10000&sysparm_offset=10000&sysparm_query=ORDERBYend_time

[v-jialongy-msft]

Hi @justingraff88 

Here's a summary of approaches that might be useful:

1. Batching Requests: One common method to circumvent the row limitation is by making multiple API requests in batches. You can use pagination parameters (like start and limit ) to fetch data in chunks within the API's constraints, then consolidate these chunks on your side for reporting.
   
   

2. Incremental Sync: Instead of trying to pull all the data at once, implement an incremental synchronization mechanism. Fetch only the records that have changed since your last sync, based on timestamps or sequence numbers. This reduces the volume of data fetched in each operation.
   
   

3. Direct Database Connection: Some organizations opt for direct connections to their ServiceNow instance's database, assuming they have the necessary permissions and security measures in place. This approach can bypass API limitations but requires a more sophisticated setup for data access and security.
   
   

4. Custom Integration Solutions: Developing a custom integration solution, such as a middleware application that interfaces with the ServiceNow API, can help manage data retrieval and processing. This solution can automatically handle API limitations, batching, and error management.

Best Regards,

Jayleny

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin]

We use a custom connector tailored to the most frequent queries. Haven't heard about any row limits.