How to explore serviceNow Data with Power BI

[leviyabl]

hi

Could anyone explain how to explore serviceNow data with power bi ?

Thanks

[Nickels]

Our instance uses SSO, so to navigate directly to the URL for the api and then to authenticate, I had to have a local password set on my user account within ServiceNow.

[Sandeep58]

Hi All, 

Can someone provide steps how to integrate Power BI with Snow?

Thanks! 

[jawwadhaq]

Hi Sandeep, that's what we all are looking for, from what I've understood there isn't any. There used to be a PowerBI connector for ITSM Incident Management which was recently deprecated. 

[Nickels]

I have been using the REST Api Explorer to generate the URL strings for the different tables that we are needing to report data out to PowerBI from. Once I have those API url's, I have setup a serviceaccount on the user table and checked the attribute, Web service access only on the record. I then have provided it with the rest_service and rest_service_explorer role as well as any read roles for tables it will be accessing based on the ACLs for that table. Example, it_project_user when accessing Project data. 

I then provide the API url's to our analytics teams and they are using the Get Date > Web option from PowerBi. https://docs.microsoft.com/en-us/power-bi/desktop-connect-to-web

I have been making sure to provide them a url that includes sysparm_display_value=all so that they are not just getting sys_id's for reference values. Depending on what they are needing to do though they are connecting to other tables such as the user table to pull additional data.

Good luck!

-Chris

[Sandeep58]

Thanks a lot Chris for elaborating the process to integrate snow with Power BI . 

Trying to go with REST API method for this one . 

Thanks,

Sandeep