ServiceNow

[mgrabowski]

Dear All,

 I have managed to integrate SN and Power Bi via official connector however when I receive data from ServiceNow it doesn't include Configuration Items. Can anyone advise on how to add them or from what  table(s) in ServiceNow data is being pulled?

[antonstorozhuk]

Hello @mgrabowski 

I would like to propose you to try out an alternative option connecting Power BI and Servicenow:

Power BI Connector for ServiceNow app

• https://store.servicenow.com/sn_appstore_store.do#!/store/application/87a42573879e0110fb5033773cbb35...
• https://www.alphaservesp.com/products/servicenow/power-bi/

We have a handy User and Admin Guides for your convenience, but feel free to reach out support team at support@alpha-serve.com if you need any assistance.

Cheers,

Anton

[v-qiuyu-msft]

Hi @mgrabowski,

You can go through all tables to see if the Configuration Items has been retrieved. If not, you need to post a thread in ServiceNow forum to consult how to retrieve Configuration Items via rest API, then you can call API in Power BI desktop to get data.

Best Regards,
QiuyunYu

[mgrabowski]

Could you advise if by the default connector should pull this information unless on the ServiceNow is specified differently?

[v-qiuyu-msft]

Hi @mgrabowski,

The ServiceNow content pack already create the dataset template. Based on my research, it doesn't retrieved Configuration Items data. You might need to consult help from ServiceNow side how client app get this data via API.

Best Regards,
QiuyunYu

[mgrabowski]

Dear All,

 I have managed to integrate SN and Power Bi via official connector however when I receive data from ServiceNow it doesn't include Configuration Items. Can anyone advise on how to add them or from what  table(s) in ServiceNow data is being pulled?