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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
uasarkar
New Member

ServiceNow

Once connect to https://app.powerbi.com/groups/me/getdata/services/servicenow through PowerBi but did not configure it. Now when I try to connect t through PowerBi its not connecting. 

In AppSource window its showing "Loading..."

 

Need help on this.

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hi @uasarkar, You can try the link below, although it mainly describes the pagination of the query, It has helped me to connect power bi and service now.

 

https://community.powerbi.com/t5/Desktop/how-to-create-a-query-that-paginates/td-p/20047 

View solution in original post

8 REPLIES 8
ltopchyi
Helper III
Helper III

Hi @uasarkar 

You can also use our Power BI Connector to connect your ServiceNow instance to Power BI.

Liubov

Anonymous
Not applicable

Hi @uasarkar, You can try the link below, although it mainly describes the pagination of the query, It has helped me to connect power bi and service now.

 

https://community.powerbi.com/t5/Desktop/how-to-create-a-query-that-paginates/td-p/20047 

Anonymous
Not applicable

Have you tried this? 

 

https://docs.servicenow.com/bundle/orlando-application-development/page/integrate/odbc-driver/task/t... 

 

I am doing it and see the entire Service Now Schema. Follow the instructions and there is a video at the very start of the article that explains what you need. 

v-yuta-msft
Community Support
Community Support

@uasarkar ,

 

You can use ODBC connector in desktop and add the service now data source to DSN, for more details, please refer to: https://www.cdata.com/kb/tech/servicenow-odbc-power-bi.rst

 

Do whitelist the port in firewall rules which is necessary and configure the gateway.

 

Regards,

Jimmy Tao

Hi, I also have same requirement, and i used ServiceNow ODBC but its showing below error while connecting.

 

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

 

Request for your assistance.

Also, is there also way to connect via API. If yes, how.

Hey Jimmy,

 

This is 3rd part toll for connecting to Service Now. What I want is to use the solution/designed method to connect to https://app.powerbi.com/groups/me/getdata/services/servicenow and thereafter giving me the option to connect to Service now which apparently worked for 1st time and now it's not populating.

 

Ujjal Sarkar

Following your post. since i am also in need to report KPIs from Servicenow on Power BI. However the ODBC connector mentioned above is not free.   I am looking for free connector or some other way to connect to Service now from Power BI.  

mylesk
Frequent Visitor

did you find a solution for this? There is the cdata connector, but as well as being a paid service its also more than I need (and will have to write my own reports).

Ideally want the servicenow powerbi app, but this no longer seems to exist

(if I try https://app.powerbi.com/groups/me/getdata/services/servicenow it just says 'loading', if I search it does not exist)

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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