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

ltopchyi's avatar
ltopchyi
Helper III
4 years ago

Hi AnandKumar10 ,

I see that it's been a while, and you've already accepted the offered solution, thanks to Community colleagues! 

Just in case you ever come to searching for another or additional integration option to fetch data from ServiceNow to Power BI, you can take a look at our app - Power BI Connector. It is available on the ServiceNow Store for a free trial. 

All the best,

Liubov