Servicenow web to connect to the API from power query

[ElizabethTachji]

Hi

I am trying to connect to servicenow tables using get data web.  In particular import into power bi desktop the incidents table.

Not wanting to use the ODBC driver but connect directly to servicenow API.

Has anybody had any luck connecting to the API and refreshing the data on Power bi service?  

Thanks in advance

Elizabeth Tachjian.

[ltopchyi]

Hi @ElizabethTachji 

You can consider a more simple option to connect ServiceNow to Power BI - it is to use a ready app for this. Power BI Connector for ServiceNow uses API in the beckgound and allows to filter the relevant data and fetch data from any tables. Hope this helps!

Liubov

[ElizabethTachji]

I cannot connect to the blog to view.  Also I worked it out.  It is just a matter of picking up the URL from SNOW API explorer.

[v-kelly-msft · Accepted solution]

Hi @ElizabethTachji ,

Check the blog below:

https://blog.kofko.xyz/connect-servicenow-and-powerbi

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!