Methods to integrate Power BI ?

[JulienRouge1549]

I'm looking into ways we can integrate Servicenow and Power Bi. I know this plugin exists  but my company is hesitant to install plugins not made by Servicenow or Microsoft so I want to know what other methods are possible. 

What other methods are possible? 

[Vishal Jaswal]

Hello @JulienRouge1549 

It is important to provide a little background on the use-case so that community can provide solutions adhering to best practices or something they have implemented in their environment.

For example: if your use-case is to retrieve all the incidents from ServiceNow into Power Bi by clicking import in Power BI and then every alternative click should bring delta i.e. new incidents from ServiceNow (if exists) and not the full refresh / fetch, then you can look at this post: https://community.fabric.microsoft.com/t5/Desktop/Connecting-data-between-ServiceNow-and-PowerBI/td-... 

[JulienRouge1549]

At the moment, this is unfortunately all the context I have, as this is just an initial dive. The clients haven't specified what they need from Power BI so I'm just trying to collect as many methods as possible. Ultimately, my job is to just connect the softwares, so I'll have to ask the client to elaborate. 

[Vishal Jaswal · Accepted solution]

@JulienRouge1549 understood! Here is what you can do which do not require any connector / plugin in PowerBI or ServiceNow.

If you want to show a dummy PowerBI report, then you can use ServiceNow PDI.

Open Power BI, click Create (+ icon) in the left and then click Get Data:

Search Web API and Click to enter following details:

To know the URL for your instance, you can login to your PDI and navigate to REST API Explorer.



NOTE: you can increase the sysparm_limit=any number in the URL field within PoweBI of your choice to show those number of incidents in PowerBI

You will get Power BI query from which you can generate report accordingly: