Forum Discussion

AnandKumar10's avatar
AnandKumar10
Regular Visitor
6 years ago
Solved

PowerBI connection with ServiceNow

Hi, I need to connect PowerBI with ServiceNow tables to prepare reports on PowerBI. Need to understand how to connect these two tools as ServiceNow currently is not available in GetData options of Po...
Need Help
  • v-kelly-msft's avatar
    v-kelly-msft
    6 years ago

    Hi AnandKumar10 ,

     

    Try the following steps:

    Install the ODBC driver to the VMs that host gateway and Power BI Desktop.

    Then add the ODBC data source within gateway, and whitelist the IP address of gateway machine and add required ports into your firewall rule.

     

    Best Regards,
    Kelly

pavelmuller's avatar
pavelmuller
New Member
6 years ago

Hi, 

 

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.

 

Kind Regards,

Pavel