What is the best way to automate the dashboard using SERVICE NOW API data to power BI tool .

[pswain]

Hi All

I am looking to automate the dashboard. Below are the details

1. I have a REST API URL

2. I have a PowerBI desktop account.

What is the best way to automate the dashboard, I do see a web URL in PowerBI, but if I use that, can I get the refreshment of the data? Kindly help.

Kindly, If you have an option, please help me with the steps, or if you have tutorial or Video you can share it to me, I can follow it.

Thanks

Prasanjit Swain

8073741806

[v-jayw-msft · Accepted solution]

Hi @pswain ,

There are several methods for you connecting to ServiceNow in Power BI.
1. Connect to ServiceNow content pack directly in Power BI Service. You can review the tutorial here.
2. Connect to ServiceNow via PBIT file in Power BI Desktop, then publish the PBIX file to Power BI Service。
3. Connect to ServiceNow using ODBC connector in Power BI Desktop, for  more details, please review this blog.

And about the data refresh, please check the offical document about Gateway.

https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-onprem 

Best Regards,

Jay

Community Support Team _ Jay Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[antonstorozhuk]

Hello @pswain 

I’d like to propose and alternative solution for you, you may connect your Servicenow instance to Power BI with the help of our add-on - Power BI Connector for ServiceNow:

• 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.

Thank you.

Regards,

Anton

===
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@pswain , refer if these can help

https://powerbi.microsoft.com/en-us/blog/explore-your-servicenow-data-with-power-bi/
https://community.powerbi.com/t5/Power-Query/Integrate-servicenow-api-with-powerbi/td-p/663781
https://community.powerbi.com/t5/Power-Query/Connecting-to-Service-Now/td-p/615037
https://community.powerbi.com/t5/Desktop/PowerBI-connection-with-ServiceNow/td-p/909414
https://community.servicenow.com/community?id=community_question&sys_id=07a77adcdbe97f40d82ffb243996...
https://www.cdata.com/kb/tech/servicenow-odbc-power-bi.rst

[TomMartens]

Hey @pswain ,

please start here with your learning:

https://docs.microsoft.com/en-us/power-bi/guided-learning/

Besides that, look for examples where other users are importing data from web APIs like Service Now, depending on the nature of the API, this can be somewhat difficult.

Here is an example of how a REST API can be used as a data source.

Regards,

Tom

[AllisonKennedy]

@pswain  I'm not sure what you mean by your point number 2 and that says you have a Power BI desktop account - you will need a PowerBI.com account to create dashboards. Login to PowerBI.com and follow the steps in this documentation to setup your dataset direct to the web service using PowerBI.com (NOT desktop) and then create a dashboard from PowerBI.com using the API data.

https://docs.microsoft.com/en-us/power-bi/connect-data/service-real-time-streaming

[pswain]

Hi,

Thanks. Do we need to have a third party connector in order to connect the S-NOW Data to Power BI? 

If I use the Web URL in the PBI connector, Is that going to refresh the automatic data in Power BI?

Thanks

Prasanjit

8073741806

[v-jayw-msft · Accepted solution]

Hi @pswain ,

There are several methods for you connecting to ServiceNow in Power BI.
1. Connect to ServiceNow content pack directly in Power BI Service. You can review the tutorial here.
2. Connect to ServiceNow via PBIT file in Power BI Desktop, then publish the PBIX file to Power BI Service。
3. Connect to ServiceNow using ODBC connector in Power BI Desktop, for  more details, please review this blog.

And about the data refresh, please check the offical document about Gateway.

https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-onprem 

Best Regards,

Jay

Community Support Team _ Jay Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[pswain · Accepted solution]

The best way to do it is to take the S-NOW API URL and copy the web connector to POWER BI, it will pull all the data in the correct format. so whatever we do the changes in records, it will update the same in Power BI. I would recommend using WEB URL connector to connect S-NOW URL to PowerBI, It will work for sure.

Let me know if any have doubts, I can reach out to you and help you on this.

Regards

Prasanjit