Connect Power BI to Service Now corporate instance.

[fcardoso00]

Hi there! I am looking for many times a way to connect power BI desktop to may service now corporate instance but It hasn´t be possible!

Could you please give me a feedbacl related this issue?

My main goal is create a executive dashboard to track incidents related my operation in much better way like Power BI gives us!

Sinceraly

Fabio Cardoso 

[v-diye-msft · Accepted solution]

Hi @fcardoso00 

I am a ServiceNow architect and I don't agree that this is the right approach. Connecting a BI tool directly to a production ServiceNow instance might significantly affect its performance.

For bigger ServiceNow instances with a lot of data, this approach won't work at all because it will take ages to download the data for your report.

There is the best practice of creating a dedicated reporting database containing a copy of the data. Either on-premise DB or an Azure one. And then connecting Power BI to this traditional database. You won't be impacting ServiceNow and the reports will be way faster.

Please use SnowMirror (https://www.snow-mirror.com/) to create such a reporting database.