Integrate ServiceNow CMDB to power BI without Connector
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
7 hours ago
Hello ServiceNow community,
We wanted to integrate ServiceNow CMDB table to power BI.
power BI connector we will not use.
These two other ways I was able to find, but how to do this configuration from ServiceNow and power BI side, if anyone can help here?
| Integration Method | Description | Pros | Cons | Suitable for |
| API Integration | Extracts data from ServiceNow by directly calling the ServiceNow REST API from Power BI. | High flexibility, real-time data retrieval, custom data extraction is possible. | Requires development skills, requires understanding of API specifications, error handling can be complex. | When development resources are available and high-level customization is required. |
| Database Connection (ODBC) | Extracts ServiceNow data into a database and connects Power BI to the database. | Suitable for processing large amounts of data, full utilization of Power BI's rich features. | Requires duplicate data management, data synchronization may be delayed, requires database construction and management. | When analyzing large amounts of data and creating complex models. |
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
6 hours ago
It depends on your use case.
If your goal is to fetch ServiceNow tables into Power BI, use REST API integration for minimal effort.
Since this involves a GET method called from the Power BI end, use the REST API Explorer in ServiceNow to build the endpoint for the Table API.
How to do this-
ServiceNow Power BI Integration: How to Connect & Get Started? | 2 Easy Methods
Note: Service Account used for this integration should only have "read" permission otherwise it may affect ServiceNow tables.
