How to Set Up Power BI ServiceNow Integration

Tired of staring at endless lists of incidents and requests inside ServiceNow? Bringing that data into Power BI transforms your service management reporting from static lists into dynamic, interactive dashboards. This guide will walk you through exactly how to set up the Power BI ServiceNow integration, step-by-step, so you can start uncovering valuable insights.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Why Bother Connecting ServiceNow to Power BI?

While ServiceNow has its own reporting features, they are often limited to basic charts and tables within the platform. Connecting it to Power BI unlocks a new level of analytical power. You can visualize incident trends over time, monitor Service Level Agreement (SLA) performance against targets, and track Key Performance Indicators (KPIs) for your IT and customer service teams.

The real advantage comes from combining data. By pulling ServiceNow data into Power BI, you can merge it with information from other business systems. Imagine a single dashboard that shows how IT incidents (from ServiceNow) impact customer support ticket volume (from Zendesk) and sales pipeline health (from Salesforce). This holistic view helps you make smarter, more informed decisions about resource allocation and process improvements.

Before You Start: What You'll Need

Getting a few things in order first will make the connection process much smoother. Here’s a quick checklist of what you’ll need:

• A Power BI Account: You'll need a Power BI Pro or Premium account to publish, share, and automatically refresh your reports. You can start building with a free account, but you'll need a paid one for advanced company-wide use.
• Power BI Desktop: This is the free application from Microsoft where you'll build your reports. Make sure you have the latest version installed on your computer.
• ServiceNow Permissions: You’ll need a ServiceNow account with at least read access to the tables you want to analyze. Roles like itil_admin or report_user often have the necessary permissions. If you're unsure, check with your ServiceNow administrator.
• Your ServiceNow Instance URL: You'll need the web address for your ServiceNow instance. It typically looks something like https://yourcompany.servicenow.com.

Connecting ServiceNow to Power BI: The Official Connector Method

Microsoft offers a built-in connector for ServiceNow, making the initial setup fairly straightforward. Follow these steps to get your data flowing into Power BI Desktop.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Step 1: Open Power BI and Find the ServiceNow Connector

Launch Power BI Desktop. In the "Home" tab of the ribbon, click on Get Data. A new window will pop up with a list of data sources. To find the right one quickly, type "ServiceNow" into the search bar. Select "ServiceNow" from the list and click Connect.

Step 2: Enter Your ServiceNow Instance URL

Next, you’ll be asked to provide your ServiceNow instance URL. Enter the full address (e.g., https://dev12345.servicenow.com). Below the URL, you’ll see two options for Data Connectivity mode: Import and DirectQuery.

• Import: This is the most common choice. Power BI imports a copy of your ServiceNow data directly into the report file. Performance is generally fast because the data is stored locally. The downside is that the data is only as fresh as your last refresh.
• DirectQuery: This mode connects live to your ServiceNow data. Every time you interact with a report (like selecting a filter), Power BI sends a query to ServiceNow to retrieve the latest data. This gives you real-time information but can be slower and less forgiving if your data model isn't optimized.

For most use cases, starting with Import mode is recommended. You can always schedule automatic refreshes in the Power BI Service later.

Step 3: Authenticate Your ServiceNow Account

After clicking "OK," Power BI will prompt you to sign in. Select the appropriate authentication method and enter your ServiceNow username and password. This is where your ServiceNow permissions come into play, Power BI will only be able to see the data that your user account has access to.

Step 4: Select Your Tables in the Navigator

Once you've successfully signed in, the Power BI Navigator window will appear. On the left side, you'll see a list of all the tables available in your ServiceNow instance that your account can access.

This is a critical step. A typical ServiceNow instance can have hundreds of tables. Loading everything will make your report slow and difficult to manage. Instead, think about the questions you want to answer and select only the necessary tables.

Common tables for service management reporting include:

• incident: For all incident management data.
• problem: For problem management records.
• change_request: For change management processes.
• sc_req_item: For requested items.
• sys_user: To relate incidents or requests to specific users.

Check the box next to each table you need. You'll see a preview of the data on the right. Once you've made your selections, you have two choices at the bottom: Load or Transform Data. Always choose Transform Data.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Step 5: Transform and Clean Your Data (Power Query)

Clicking "Transform Data" opens the Power Query Editor. This is where you can clean and shape your data before loading it into your report. Doing this work upfront is essential for building fast and efficient dashboards. Rushing past this stage and loading raw, unfiltered tables is the most common mistake people make.

Here are a few essential transformations you should consider:

• Remove Unnecessary Columns: Your ServiceNow tables might have over 100 columns each. Most of them are system IDs or fields you'll never use. Select the columns you need and use the "Remove Other Columns" option. This drastically reduces the size of your data model.
• Filter Rows: Do you really need to analyze incidents from five years ago? Probably not. Use the filter options to narrow down the data. For example, you might filter the incident table to only include incidents created in the last year.
• Correct Data Types: Ensure dates are recognized as date/time types, numerical values are numbers, and so on. Power Query is usually good at guessing, but it's always wise to double-check.

Once you’re happy with a clean, focused dataset, click Close & Apply in the top-left corner of the Power Query Editor.

Step 6: Build Your Report

Power BI will now load your transformed data into the report model. Once it's finished, you're ready to build! In the "Fields" pane on the right, you'll see the tables and columns you loaded. Simply drag and drop fields onto the report canvas and choose your visualizations to start creating charts, graphs, and KPIs.

Common Issues and Quick Fixes

Sometimes you run into a snag. Here are a few common issues and how to troubleshoot them.

"I can't see the tables I need in the Navigator."

This is almost always a permissions issue. Your ServiceNow user account likely doesn't have read access to the specific tables you're looking for. Contact your ServiceNow administrator and ask them to grant you the necessary permissions (also known as Access Control Lists or ACLs).

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

"My scheduled data refresh is failing."

When you publish your report to the Power BI Service and schedule a refresh, it might fail. The most common cause is an expired credential. Go to your dataset's settings in the Power BI Service, find the "Data source credentials" section, and re-enter your ServiceNow login information.

"The initial data load is taking forever!"

If Power BI is struggling to import the data, you're pulling too much at once. Go back into the Power Query Editor (click "Transform Data" on the Home ribbon) and be more aggressive with your filtering. Limit the date range (e.g., only the last 365 days) and remove more columns. The less data you import, the faster your report will be.

Putting It All Together: Ideas for Your ServiceNow Dashboard

Now for the fun part. Once your data is connected, what should you actually build? Here are a few ideas to get you started:

• IT Incident Dashboard: Create visuals showing open incidents by priority, incidents by assigned group, mean time to resolution (MTTR), and a trend line of created vs. resolved incidents over time.
• SLA Performance Dashboard: Track your SLA compliance rate. Use a gauge visual to show the percent of tickets solved within SLA, and a table to highlight the specific tickets that have breached their SLAs.
• Change Management Report: Monitor the volume of change requests by status (pending, approved, implemented), the change success rate (changes that didn't lead to new incidents), and the number of emergency changes.
• Team Performance Scorecard: Analyze resolved incidents and completed requests by assignee to understand workload distribution and identify top performers.

Final Thoughts

Integrating ServiceNow with Power BI moves you from basic data lists to powerful, interactive dashboards that can uncover serious operational insights. The process is straightforward with the native connector, and the key to success lies in thoughtfully transforming your data before you load it, ensuring your reports are both fast and focused.

We know that even with a connector, managing data models and configuring reports can be time-consuming, especially when you need to combine data from multiple platforms. That's why we're building Graphed . We simplify the entire reporting workflow by letting you connect all of your marketing and sales data sources and then using simple, natural language to create the dashboards you need instantly. Instead of spending hours in Power BI, you can get insights from your various platforms in seconds and get back to making data-driven decisions.