How we can integrate ServiceNow and PowerBI using Flow designer

SharathKonana
Tera Contributor

I have a requirement where we need to integrate with ServiceNow with PoweBI how we can achive it by using Flow designer

3 REPLIES 3

Dr Atul G- LNG
Tera Patron

Hi @SharathKonana 

 

https://www.servicenow.com/community/platform-analytics-articles/how-to-set-power-bi-servicenow-inte...

CC: @Anna Odrynska 

*************************************************************************************************************
Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/dratulgrover [ Connect for 1-1 Session]

****************************************************************************************************************

Ankur Bawiskar
Tera Patron

@SharathKonana 

there is a store paid app for this from ServiceNow Store

Your customer will have to purchase it

Power BI Connector 

this link talks about the setup

How to Set Power BI ServiceNow Integration: Complete Guide 

if your customer is not willing to pay then you will require custom API based integration for this

check with Power BI team about their API and how you can send request

Using the Power BI REST APIs 

AnkurBawiskar_0-1771508106020.png

 

💡 If my response helped, please mark it as correct and close the thread 🔒— this helps future readers find the solution faster! 🙏

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

Tanushree Maiti
Mega Sage

Power BI connector is there to integrate servicenow and Power BI.

 

Key feature:

  • Export any ServiceNow tables and fields (including Custom tables and fields)
  • Include any amount of tables and fields to your Data Source
  • Create any amount of Data Sources (data sets)
  • There are no limitations in exported data. To reduce the server load during the export process, the application provides the server-side pagination of data over the OData protocol (limited to 1.000 rows per page)
  • Advanced filtering options to manage data selection and export only the relevant information
  • Robust permission settings and access management for secure data sharing
  • Dot-walking mechanism for exporting Reference type data, allowing easy access and inclusion of fields from related tables
  • Incremental refresh support for efficient Power BI reports and dashboards updates without reimporting the entire dataset
  • Power Query support (merge ServiceNow with other data sources, transform data and load it into Power BI Desktop with no-code experience)
  • Pre-typed data, eliminating the need for manual conversion to target types such as integer, boolean, decimal, etc
  • Intuitive and familiar user interface through the ServiceNow portal
  • Designed for high availability and performance at scale
  • Qualified Technical Support Team
  • Helpful User/Admin Guide

 

Ref: 

How to Set Power BI ServiceNow Integration: Comple... - ServiceNow Community

Power BI Connector - ServiceNow Store

Please mark this response as Helpful & Accept it as solution if it assisted you with your question.
Regards
Tanushree Maiti
ServiceNow Technical Architect
Linkedin: