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

v-kelly-msft's avatar
v-kelly-msft
Community Support
6 years ago

Hi AnandKumar10 ,

 

Try using web connector,steps are as follows:

 

 

 

References pls click here.

 

 

 

Best Regards,
Kelly

  • AnandKumar10's avatar
    AnandKumar10
    Regular Visitor
    6 years ago

    Thanks but it didn't worked. i tried odbc but its showing below error

     
     

    Details: "ODBC: ERROR [HY000] [SN][ODBC ServiceNow driver][OpenAccess SDK SQL Engine]Cannot create schema.Cannot retrieve a DB schema. Please run <instance>?SCHEMA in your browser and try again. Also make sure that the table descriptor cache can hold all your tables and DB views. You can check the table descriptor stats runing <instance>/xmlstats.do in your browser.[1050]"

    • v-kelly-msft's avatar
      v-kelly-msft
      Community Support
      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

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi 

     

    Would like to double check what is the URL is ?

     

    Daisy