Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

Reply
AnandKumar10
Regular Visitor

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 Power BI

1 ACCEPTED SOLUTION

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

View solution in original post

7 REPLIES 7
Pbidev342
Helper I
Helper I

I found a video guide on YouTube. This helped us;

 

https://youtu.be/vz2iHuhTAXM?si=qJtUowqBYKycxuOl

ltopchyi
Helper III
Helper III

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

pavelmuller
New Member

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

v-kelly-msft
Community Support
Community Support

Hi @AnandKumar10 ,

 

Try using web connector,steps are as follows:

 

5.png6.png

 

 

References pls click here.

 

 

 

Best Regards,
Kelly

Anonymous
Not applicable

Hi 

 

Would like to double check what is the URL is ?

 

Daisy

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]"

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

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.