Power BI Connector for ServiceNow

Operate without any coding or technical skills. Export ServiceNow data to Power BI and start building reports immediately, without developers or ServiceNow consultants.

Install directly from the ServiceNow Store and start exporting data to Power BI in minutes, without extensive training or professional services.

Access the connector from the standard ServiceNow Service Portal or the Power BI Connector page.

Create a new data source from scratch, generate one automatically from an existing ServiceNow report, or jumpstart with one of five pre-built dashboard templates

Export unlimited ServiceNow data to Power BI with no restrictions on the amount of records, tables, or fields, ensuring comprehensive data analysis without constraints.

Create an unlimited number of named data sources, each independently configured for specific reports or datasets, to organize and reuse exports across teams and projects.

Provide connector access to all team members based on their assigned roles, with no additional per-user costs beyond the base license.

Export data from any standard ServiceNow table — Incident, Problem, Change, Request, Configuration Items, and more — for reporting and analytics in Power BI.

Export custom ServiceNow tables and fields tailored to your business processes, alongside standard modules, with no restrictions on custom schema.

Export Reference type fields by selecting the parent field and any child fields from the referenced table. The connector clearly identifies reference-type fields in the field picker for easy selection.

Navigate deeply into related table dependencies using dot-walking to select child and nested child fields from Reference type columns — not just the top-level reference value — without writing queries or joins.

Export Variables type data from ServiceNow catalog items and forms by exporting the relevant related tables, then merging them in Power BI Desktop to reconstruct variable values per request item.

Export ServiceNow Database Views — pre-joined virtual tables combining data from multiple source tables — giving access to complex multi-table datasets without manual joins in Power BI. Available to ServiceNow Admins.

Export duration fields as numeric values in seconds, so time-based ServiceNow data is easier to calculate, compare, and visualize in BI reports.

Toggle "Use display value" per field or globally to export human-readable string labels instead of raw system values, making reports immediately understandable to business users.

Replace technical system field names with user-friendly display labels as column headers in Power BI, improving report readability without manual renaming after export.

Build multi-condition filter logic directly in the data source configuration interface to precisely narrow down exported records – no query language required.

Use standard OData operators ($filter, $select, $top, $skip, $orderby, $search, $count) via Power Query in Power BI Desktop for advanced post-export data transformation and filtering.

Set an optional row export limit per data source to cap dataset size for testing or performance management. Leave blank for unlimited record export.

Trigger on-demand data refreshes at any time to pull the latest ServiceNow data into published Power BI reports and dashboards without republishing.

Configure automated refresh schedules on Power BI Service to keep reports updated with current ServiceNow data at defined intervals — daily, weekly, or custom — removing the need to manually republish.

Configure incremental refresh policies to load only new or changed records rather than re-importing full datasets on each refresh, reducing processing time and load on the ServiceNow instance.

Two-tab Power BI template covering the current state of all incidents (open incidents by priority, urgency, and status) and performance trends (resolution times, incident volume over time).

Centralized view of all identified problems including status, urgency, impact, and priority — with both current state and performance trend analysis tabs for root cause tracking.

Overview of service request fulfillment including related catalog items, tasks, stage, and priority — with current state snapshot and performance-over-time views for SLA and volume tracking.

Visual change management funnel tracking requests from submission through implementation, with KPIs such as average closure days, urgency breakdown, and accumulated open requests by priority.

Comprehensive view of IT infrastructure across category, manufacturer, operational status, install status, class, and cost center for CMDB visibility and asset management reporting.

Three built-in roles — PBI Admin (read/write/create/delete), PBI Editor (read/write/create), and PBI Viewer (read-only) — give ServiceNow admins fine-grained control over who can create and manage data sources.

Restrict editing of a data source to its owner, selected user groups, or ServiceNow admins only — preventing accidental changes to shared configurations used across multiple reports.

The connector enforces existing ServiceNow table and field-level access controls. Users can only export data from tables they are authorized to access — enforced at the data source level with clear access indicators.

Merge ServiceNow data with other sources — CRM, ERP, Jira, financial systems, and more — using Power Query in Power BI Desktop for unified, cross-platform business reporting without coding.

Use a Blank Query Connection with a pre-generated access token template to write custom M queries and access ServiceNow data directly in Power BI, enabling advanced transformation and complex data modelling scenarios.

View the full schema map for any data source — showing table structure, field names, types, and relationships — to understand and validate data models before loading into Power BI.

Preview export results for a data source directly in ServiceNow before connecting to Power BI, enabling quick validation of field selections and filter logic without a full export.

The connector does not collect, store, or share any customer data. All data remains exclusively on the customer's ServiceNow instance and is transferred directly to the user's Power BI environment.

Connect Power BI to ServiceNow instances secured with multi-factor authentication, two-factor authentication, or single sign-on using supported authentication flows and token-based access.

Configure a custom OAuth access token lifespan to align with your organization's security policies and session management requirements.

Track the full change history for each data source, giving administrators an audit trail to review configuration changes, field updates, and filter modifications over time.

View a complete log of all export events per data source — including timestamps and export details — to monitor usage patterns and troubleshoot data freshness issues.

Migrate created data sources between different ServiceNow instances — for example when promoting from development to production — without rebuilding configurations from scratch.

Configure the connector to be fully accessible through the ServiceNow Service Portal, allowing end users to create and manage data sources within the portal experience they already use.

Built to export large data volumes without impacting performance on the ServiceNow instance, ensuring production environments remain stable and responsive during data exports.