Connect ServiceNow to Power BI

[SM_1997_]

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.

[Pbidev342]

This video guide is what I referred to set it up for my team

https://youtu.be/vz2iHuhTAXM?si=qJtUowqBYKycxuOl

[Syndicate_Admin]

Hello @Syndicate_Admin

You might want to try an alternative solution? We've built an app for Servicenow and Power BI integration: Power BI Connector for Servicenow. It's easy to use, it's fast and automated. Feel free to DM me in you want to Trial it or need any assistance.

Cheers!

Anton

===

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Mary_aj]

Please tell me if this will work with the Power BI Server.

[aj1973]

Hi @SM_1997_ 

It could work, but why you don't connect directly to SQL server without ODBC?

[SM_1997_]

How would I go about that? Is there a chance it could hurt the performance?

[aj1973]

@SM_1997_ 

The performance of a report doesn't rely on the mode of connection to the source.

[SM_1997_ · Accepted solution]

Oh oops I just realized, It'll be like: ServiceNow Instance > ODBC Driver > SQL > Power BI