Power BI Server and ServiceNow

[Mary_aj]

Hi,

Does anyone have experience integrating two systems using ODBC or REST API?

Can you share how this was implemented? Incremental loading is especially interesting.

Thanks 

[lbendlin · Accepted solution]

In our company we created a custom connector for that, and installed in on all our gateways.  It only covers a few select actions, but is good enough for our needs.

[v-yohua-msft · Accepted solution]

Hi, @Mary_aj 

To use ODBC, you first need to install the ODBC driver for ServiceNow. Set up an ODBC data source and fill in the necessary ServiceNow instance details. In Power BI, go to the Get Data section, select ODBC, and select the configured data source. To achieve incremental loading, you can use Power BI's incremental refresh feature. This involves setting parameters in Power Query to filter data based on date/time fields and configuring an incremental refresh policy in the Power BI data model.

You can check the following link:

How to connect Power BI to ServiceNow using ODBC - Microsoft Fabric

Creating a REST API call to get data from ServiceNow requires an understanding of ServiceNow's API endpoints and authentication methods. Use Power BI's web connector to make API calls and import data. Incremental loading works similarly to the ODBC approach, where incremental refresh can be set up by defining parameters in Power Query to fetch only new or updated records based on timestamps. You can check the following links:

Connect ServiceNow to Power BI: REST API vs Power BI Connector

Optimizing Business Insights: Power BI ServiceNow Integration - Techicy

Incremental Refresh in Power BI, Part 1: Implementation in Power BI Desktop - BI Insight

How to Get Your Question Answered Quickly

Best Regards

Yongkang Hua

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

[lbendlin · Accepted solution]

In our company we created a custom connector for that, and installed in on all our gateways.  It only covers a few select actions, but is good enough for our needs.

[Mary_aj]

Thanks for sharing 😊