How to explore serviceNow Data with Power BI

[leviyabl]

hi

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

Thanks

[Mike19]

Nickels, can you clarify what you did to provide the sysparm_display_value=all so we don't just get sys_id's?

Also, our values for "Created By" etc are not names but user id's, Is a solution to add the "user" table to our url list, and then add a relationship in Power BI so the reporting can show the user name instead of an id?

Thanks for any clarification.

Mike

[pavelmuller]

Hi, 

IMHO, connecting a reporting tool directly to a production system is not a good idea at all. Not mentioning that it will be very slow if you have many records.

The best practice is creating a dedicated reporting database containing replicated data and connection PowerBI to this DB.

The benefits are obvious. The reporting is way faster and you are not impacting your production instance.

You can use tools such as SnowMirror to create a mirror DB.

Kind Regards,
Pavel

[Anna Odrynska]

Hi All,

There is an app to connect ServiceNow to Power Bi - Power BI Connector. It allows to pull data from any tables (not only incidents) which you have permissions to in your ServiceNow instance. 

Anna

[Khrystyna Shpar]

Hi!

You can consider Power BI Connector as a means to integrate both platforms and pull ServiceNow data into Power BI for further use.

Cheers,

Khrystyna

[Anna Odrynska]

Hi @leviyabl 

You can take a look a this instruction: https://www.acsoftinc.com/servicenow-power-bi-integration-your-ultimate-faq-guide/ 

Anna