ServiceNow and Power BI Integration

Bharat Shinde
Tera Contributor

‎11-15-2023 02:10 AM

Hi,

One of the requirement we have is to present ServiceNow data into Power BI. The option we explored is Table API which works fine with Power BI. But the issue is that we would like to have incremental data from ServiceNow and not whole data set on refresh as there will be lot of data in SN tables.

 

We have some limitation to use any third-party paid connector.

Is this possible with SN OOTB REST API with incremental refresh?

Or do we have to push data to SQL server first and then read from Power BI. But there will be lot of tables and data which needs to be keep in sync between SN and SQL server.

 

Any thoughts?

 

Regards,

Bharat.

0 Helpfuls
  • 1,589 Views
2 REPLIES 2

Maik Skoddow
Tera Patron
Tera Patron

‎11-15-2023 02:58 AM - edited ‎11-15-2023 03:00 AM

Hi @Bharat Shinde 

yes, this is possible. In the table API you have to option to to pass an encoded query. And for incremental queries you can use something like:

sys_updated_onONYesterday@javascript:gs.beginningOfYesterday()@javascript:gs.endOfYesterday()


which returns all yesterday's updated records for the specified table.

Maik

0 Helpfuls

Bharat Shinde
Tera Contributor
In response to Maik Skoddow

‎11-15-2023 06:33 AM - edited ‎11-15-2023 06:34 AM

Hi @Maik 

Thank you for your response.

 

Yes I have used those options to get just updated data for last day etc. but in Power BI first we need to have all data and then just delta so in reports user can see all data (old + incremental/delta). 

If I tried to execute rest api call with filter then it only brings the query satisfying data in power bi table.

 

I would like to update the data in power bi table (old + new), some articles says query folding is not supported in power bi for REST api calls like it support for sql db, so not sure if this can be achieved with rest api call.

0 Helpfuls