ServiceNow Table API to extract data for Power BI

[kbkrabbenhoft]

Ok guru's I am working on a plan that would allow table data stored in ServiceNow to be visible to users in Power BI. I have proven this will work in the lower instance (dev) using the URL for the table basic auth as POC. I will create a dedicated integration pbi_user once in production. My question? I want to ensure the table API is the right solution. The table is very large and has many references to other tables. Does anyone have any thoughts on this. My company is very heavy on spreadsheets. 

[Tanushree Maiti]

Hi @kbkrabbenhoft 

All three ways you will get from here with screen shot :https://aithority.com/technology/analytics/business-intelligence/3-ways-to-export-servicenow-data-to...

1. Lightweight reporting and real-time data needs. , use Rest API (Table API )

2.For  Large data volumes, complex data models (e.g., dot-walking), and users without coding skills. , powerBI connector is best solution.

How to Set Power BI ServiceNow Integration: Complete Guide

https://www.youtube.com/watch?v=2wIGxDWJRqE

Also you can check: Interconnecting Power BI with ServiceNow to create dynamic report 

[Vishal Jaswal]

Hello @kbkrabbenhoft 

Yes, table API is the right solution; you can refer to this thread for such assistance: https://www.servicenow.com/community/platform-analytics-forum/methods-to-integrate-power-bi/m-p/3521... 

For large data, ensure to do Power BI incremental refresh fetching only new or updated records based upon ServiceNow's sys_updated_on field value.

For reference field values, expect them to be seen as sys_id (alpha-numberic values), however to see their actual Display value, please reference to "Best Practices and Common Hurdles" section of this article/guide here: https://www.thebricks.com/resources/guide-how-to-get-servicenow-data-in-power-bi