Best way to connect ServiceNow to Power BI?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-16-2022 07:49 AM
Hello all,
I am currently working on a process to connect our ServiceNow instance to Power BI. I wanted to ask about best options and practices. I am considering connecting an ODBC driver to our ServiceNow instance which will then connect to a SQL server database which will connect to the dashboard I have created.
Is this the best way to go about the connection or is there a better way? Also is the SQL database really necessary or will only using the ODBC driver suffice?
Thanks.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-17-2024 02:02 AM
Connecting ServiceNow to Power BI via an ODBC driver directly can be efficient. However, using a SQL database as an intermediary can offer more control over data handling. Alternatively, consider using a cloud integration platform like Skyvia, which provides a direct, user-friendly connection without the need for additional SQL database setup.