Best way to connect ServiceNow to Power BI?

[NomisKeem]

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.

[sachin_namjoshi]

PowerBI provides REST API.

You can use REST API to integrate both the platforms.

Regards,

Sachin

[NomisKeem]

Thanks for the advice, would you say that it's better than using an ODBC driver?

[anitha0887]

Hi Sachin, can you evaborate how to integrate using Rest message API.

[anitha0887]

Hi @sachin_namjoshi ,

can you help me on this issue, iam getting credential issues, what could be cause to get following error.