Fetching data from ServiceNow in power query

[Shree]

How can I fetch data from ServiceNow from Power Query? Can you please help me with the approach , if I want the data from Service now of MSR, DTR , Change to be visible in power BI desktop.

[Pbidev342]

Refer this step by step guide

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

[ltopchyi]

Hi @Shree ,

In addition to the option provided below, if you are looking for one more way to work with ServiceNow data in Power Query, you can try for free the relevant app - Power BI Connector, it is available on the ServiceNow Store.

BR,

Liubov

[v-shex-msft · Accepted solution]

Hi @Shree,

I think power query web connector with ServiceNow api will suitable for your scenario:

ServiceNow REST API Reference

Regards,
Xiaoxin Sheng

[Shree]

Thanks Sheng for your response.. I had gone through it, but as I am new to this. I really do not understand how to use it. If you could help me through that.

Is this for which I need to understand Java Script?