Has anyone integrated ServiceNow with Power BI?

[Brian O_Donnell]

We are looking to utilize powerbi.com for data analytics of our ServiceNow data.   They are utilizing OData connection.

Wondering if anyone has had experience using something like this and how you were able to access the data.   We seem to be having connection problems.   We can connect by using the basic REST functionality with basic auth, but are getting errors trying with OData and my thought is that I must have a header incorrect.

[tony_barratt]

Hi Brian,

I have not direct experience of OData, perhaps another Community Member will post their experiences.

However, I too would suspect incorrect or missing   headers.

Looking in the docs I see that headers that relate to version - of OData - might be required as well as headers related to content.

Operations | OData - The Protocol for REST APIs

JSON Verbose Format | OData - The Protocol for REST APIs

Do you see any helpful error messages?

Best Regards

Tony

[Brian O_Donnell]

Was able to meet with the group that is trying to extract the data - magically started working.   Apparently they fixed the header issue.   The only other interesting item was that we got caught by the default page size of 10000 records.

Going to look into ServiceNow Data Mart Loader download | SourceForge.net to see if that will help pull the data over since i don't think that there is a need to change the paging - i don't think we want to pull more data than that anyway in our prod environment.   Also the paging information is provided in the headers of the response, so they should be able to manage the paging easily from there if the Data Mart Loader doesn't look like a good fit.

Thanks for your suggestions!

[acarter]

Brian,   Did you get this working?   We are exploring Power BI as well.

AC

[Brian O_Donnell]

Yes we did.   The articles that Tony recommended are a good place to start.   I didn't actually work with it a lot as I was the ServiceNow resource, and there was another team working on the Power BI side.   From what I gathered, it was pretty easy to get it to work.   I just had to create an account and add the appropriate security.

For what its worth, we have not decided on a path forward yet.   We are also looking at some third party vendors that provide the data synchronization as a service.