ServiceNow Table API to extract data for Power BI

kbkrabbenhoft
Tera Contributor

57m ago

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. 

 

Karen Krabbenhoft
0 Helpfuls
  • 66 Views
1 REPLY 1

Tanushree Maiti
Mega Patron

34m ago

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 

Please mark this response as Helpful & Accept it as solution if it assisted you with your question.
Regards
Tanushree Maiti
ServiceNow Technical Architect
Linkedin:
Power BI Connector for ServiceNow Demo: General and Administrative Settings Overview
Power BI Connector for ServiceNow Demo: General and Administrative Settings Overview
youtube.com/watch?v=2wIGxDWJRqE
Welcome to the demo of the Power BI Connector for ServiceNow, focusing on general and administrative settings. This video will guide you through the essential configurations to optimize your Power BI ServiceNow integration. Whether you're an IT administrator overseeing system-wide deployments or a
0 Helpfuls