Power BI Server and ServiceNow

Mary_aj — Thu, 31 Oct 2024 06:40:23 GMT

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

Re: Power BI Server and ServiceNow

lbendlin — Thu, 31 Oct 2024 10:39:27 GMT

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.

Re: Power BI Server and ServiceNow

Mary_aj — Thu, 31 Oct 2024 12:15:31 GMT

Thanks for sharing 😊

Re: Power BI Server and ServiceNow

Anonymous — Fri, 01 Nov 2024 02:25:26 GMT

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.

topic Power BI Server and ServiceNow in Report Server

Power BI Server and ServiceNow

Re: Power BI Server and ServiceNow

Re: Power BI Server and ServiceNow

Re: Power BI Server and ServiceNow