---
title: "Power BI: How to Set Up the Integration"
description: Gain new insights by adding real-time project, task and team data to your Power BI reports and dashboards.
---

[Skip to content](https://learn.projectmanager.com/power-bi#main-content)

English

Show submenu for translations

[Ask a Question](https://learn.projectmanager.com/kb-tickets/new)

![](https://learn.projectmanager.com/hs-fs/hubfs/2022-PM-Logo-01.png?width=40&height=31&name=2022-PM-Logo-01.png)

- [ProjectManager Knowledge Base](https://learn.projectmanager.com/)

Open main navigation

Close main navigation

- [ProjectManager Knowledge Base](https://learn.projectmanager.com/)
- English
  
  Show submenu for translations
- [Ask a Question](https://learn.projectmanager.com/kb-tickets/new)

 How can we help you today?

- There are no suggestions because the search field is empty.

1. [ProjectManager Knowledge Base](https://learn.projectmanager.com/)
2. [Integrations](https://learn.projectmanager.com/integrations)
3. [Analytics](https://learn.projectmanager.com/integrations#analytics)

# Power BI: How to Set Up the Integration

## Gain new insights by adding real-time project, task and team data to your Power BI reports and dashboards.

| [Connect via Online](https://learn.projectmanager.com/power-bi#Online) | [Connect via Desktop](https://learn.projectmanager.com/power-bi#Desktop) | [Connect via Power Query](https://learn.projectmanager.com/power-bi#PowerQuery) |
| --- | --- | --- |
| [Data Model](https://learn.projectmanager.com/power-bi#PrimaryData) | <https://learn.projectmanager.com/power-bi#Reference>[Example Reports](https://learn.projectmanager.com/power-bi#Reports)<https://learn.projectmanager.com/power-bi#Reference> |  |

 

This feature is included in the Enterprise edition; it can also be added to the Business plan as part of our Integrations Bundle. [Upgrade your plan today!](http://app.projectmanager.com/go/subscribe)

 

Power BI is a business analytics tool that visualizes data. It can be integrated with ProjectManager to add project data analysis and reporting capabilities.

- Real-time data synchronization automatically updates Power BI reports and dashboards with latest project data.
- Merge project data with other business data sources within Power BI to create tailored reports.

Power BI enhences key ProjectManager features, such as task and project tracking, resource management, time tracking, budgeting and cost tracking, team collaboration metrics, risk management and portfolio management.

### Getting Started

There are three things you'll need to get from your ProjectManager account before you head over to Power BI or Power Query to set up the feed:

1. **oData URL** → [Activate Power BI](http://app.projectmanager.com/go/integrations/power-bi) within ProjectManager to get your data feed URL
2. **API Key** → [Generate an API key](https://learn.projectmanager.com/find-your-api-key) within ProjectManager to use with Power BI
3. **Account Email** → The email address you log in to ProjectManager with

### Connect via Power BI Online

From your workspace, select *New,* then *More Options:*

*![](https://learn.projectmanager.com/hs-fs/hubfs/Screenshot%202023-10-31%20at%202-31-11%E2%80%AFPM-png.png?width=400&height=339&name=Screenshot%202023-10-31%20at%202-31-11%E2%80%AFPM-png.png)*

Choose *Dataflow Gen2* as the data source:

![](https://learn.projectmanager.com/hs-fs/hubfs/Screenshot%202023-10-31%20at%202-31-26%E2%80%AFPM-png.png?width=400&height=187&name=Screenshot%202023-10-31%20at%202-31-26%E2%80%AFPM-png.png)

Enter your oData information on the following screen to connect to your data:

![](https://learn.projectmanager.com/hs-fs/hubfs/Screenshot%202023-10-31%20at%202-47-09%E2%80%AFPM-png.png?width=550&height=364&name=Screenshot%202023-10-31%20at%202-47-09%E2%80%AFPM-png.png)

- **URL** → Paste the oData URL you received when activating the integration
- **Connection** → Choose "Create new connection"
- **Authentication kind** → Choose "Basic"
- **Username** → The email you log into ProjectManager with
- **Password** → The API key you created at the start of this process

From here, you can choose which tables you would like to connect to and build a query:

![](https://learn.projectmanager.com/hs-fs/hubfs/BI%20Import%20with%20Extra%20Tables%20(Large)-png-1.png?width=670&height=391&name=BI%20Import%20with%20Extra%20Tables%20(Large)-png-1.png)

Alternate connection methods and troubleshooting:

- [Connect to oData in Power BI dataflows](https://learn.microsoft.com/en-us/fabric/data-factory/connector-odata-dataflows)
- [Create an oData connection using Fabric](https://learn.microsoft.com/en-us/fabric/data-factory/connector-odata)
- [Import an OData source using Azure Data Factory](https://learn.microsoft.com/en-us/azure/data-factory/connector-odata?tabs=data-factory)

Want to talk to an expert about our features?[**Join a live demo**](https://www.projectmanager.com/pm/weekly-demo?utm_campaign=weekly-demo&utm_medium=knowledge-base&utm_content=powerbi) this week and get a real-time walkthrough of ProjectManager.

### Connect via Power BI Desktop

To add a feed, open Power BI, click *New Source* then *oData Feed*:

![](https://learn.projectmanager.com/hs-fs/hubfs/get_odata-png.png?width=219&height=478&name=get_odata-png.png)

Paste your oData feed into the URL field and click OK:

![](https://learn.projectmanager.com/hs-fs/hubfs/get_odata2-png.png?width=670&height=211&name=get_odata2-png.png)

In some versions of Power BI you may see this layout instead:

![](https://learn.projectmanager.com/hs-fs/hubfs/Frame%203191-png-3.png?width=550&height=247&name=Frame%203191-png-3.png)

Authentication information should be entered as follows:

- **Authentication kind** → Choose "Basic"
- **User name** → The email you log into ProjectManager with
- **Password** → The API key you created at the start of this process

From here, you can choose which tables you would like to connect to and build a query:

![](https://learn.projectmanager.com/hs-fs/hubfs/BI%20Import%20with%20Extra%20Tables-png.png?width=670&height=330&name=BI%20Import%20with%20Extra%20Tables-png.png)

Further reading and troubleshooting:

- [Connect to data in Power BI Desktop](https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-quickstart-connect-to-data#connect-to-data)
- [Combining data sources in Power BI](https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-shape-and-combine-data)
- <https://learn.microsoft.com/en-us/power-query/connectors/odata-feed>[Data sources overview for Power BI](https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-data-sources)
- [Data refresh in Power BI](https://learn.microsoft.com/en-us/power-bi/connect-data/refresh-data)

 

Want to talk to an expert about our features? **[Join a live demo](https://www.projectmanager.com/pm/weekly-demo?utm_campaign=weekly-demo&utm_medium=knowledge-base&utm_content=powerbi)** this upcoming Thursday and get a real-time walkthrough of ProjectManager. 

### Connect via Power Query

The instructions above for connecting Power BI Online will usually work for Power Query, start from the ribbon and follow the steps above:

![](https://learn.projectmanager.com/hs-fs/hubfs/Screenshot%202023-11-06%20at%209-58-41%E2%80%AFAM-png.png?width=400&height=258&name=Screenshot%202023-11-06%20at%209-58-41%E2%80%AFAM-png.png)

Once you've completed the steps above you'll be able to generate queries based on your ProjectManager data:

 

![](https://learn.projectmanager.com/hs-fs/hubfs/BI%20Data%20Preview%2c%20Task%20Todos%20(Power%20Query)-png.png?width=670&height=383&name=BI%20Data%20Preview%2c%20Task%20Todos%20(Power%20Query)-png.png)

### Data Model

Please see the following article for information on the fields and relationships available via the PowerBI integration:

- [ProjectManager PowerBI Data Model](https://learn.projectmanager.com/powerbi-data-model)

Further reading and troubleshooting (via Microsoft):

- <https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-quickstart-connect-to-data#connect-to-data>[Setting up oData feeds in Power Query Desktop](https://learn.microsoft.com/en-us/power-query/connectors/odata-feed)<https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-quickstart-connect-to-data#connect-to-data>
- [Working with oData feeds in Power Query](https://learn.microsoft.com/en-us/power-query/power-query-ui)

### Generate Reports

You're free to generate dedicated task, project or resource reports to suit your business needs. You can also combine this data (such as project budgets and target dates) with your existing reports to see the big picture.

Below are some very simple examples of data you can extract from our integration:

**Task Progress Matrix**

![](https://learn.projectmanager.com/hs-fs/hubfs/image%20(1)-png.png?width=670&height=363&name=image%20(1)-png.png)

**Annual Project Completion Rate**

![](https://learn.projectmanager.com/hs-fs/hubfs/image-png-Dec-05-2023-09-04-15-4044-PM.png?width=670&height=178&name=image-png-Dec-05-2023-09-04-15-4044-PM.png)

- [Training walkthroughs](https://learn.projectmanager.com/training-walkthroughs#main-content)

    - [Setting Up Your Account](https://learn.projectmanager.com/training-walkthroughs#setting-up-your-account)
    - [Resource Management](https://learn.projectmanager.com/training-walkthroughs#resource-management)
    - [Team Management](https://learn.projectmanager.com/training-walkthroughs#team-management)
    - [Gantt Chart](https://learn.projectmanager.com/training-walkthroughs#gantt-chart)
    - [Dashboards](https://learn.projectmanager.com/training-walkthroughs#dashboards)
    - [Portfolio Management](https://learn.projectmanager.com/training-walkthroughs#portfolio-management)
    - [Integrations](https://learn.projectmanager.com/training-walkthroughs#integrations)
- [Getting started](https://learn.projectmanager.com/getting-started#main-content)

    - [Software Basics](https://learn.projectmanager.com/getting-started#software-basics)
    - [Account Basics](https://learn.projectmanager.com/getting-started#account-basics)
    - [Making Your First Project](https://learn.projectmanager.com/getting-started#making-your-first-project)
    - [Preferences & Notifications](https://learn.projectmanager.com/getting-started#preferences-notifications)
- [Managing projects](https://learn.projectmanager.com/managing-projects#main-content)

    - [Project Management](https://learn.projectmanager.com/managing-projects#project-management)
    - [Project Settings](https://learn.projectmanager.com/managing-projects#project-settings)
    - [Templates, Imports & Exports](https://learn.projectmanager.com/managing-projects#templates-imports-exports)
- [Project views](https://learn.projectmanager.com/project-views#main-content)

    - [Our Project Views](https://learn.projectmanager.com/project-views#our-project-views)
    - [List, Board & Calendar Views](https://learn.projectmanager.com/project-views#list-board-calendar-views)
    - [Gantt View](https://learn.projectmanager.com/project-views#gantt-view)
    - [Sheet View](https://learn.projectmanager.com/project-views#sheet-view)
    - [Risk View](https://learn.projectmanager.com/project-views#risk-view)
- [Tasks & teams](https://learn.projectmanager.com/tasks-teams#main-content)

    - [Task Management Basics](https://learn.projectmanager.com/tasks-teams#task-management-basics)
    - [Advanced Task Management](https://learn.projectmanager.com/tasks-teams#advanced-task-management)
    - [Team Organization](https://learn.projectmanager.com/tasks-teams#team-organization)
    - [Team Management](https://learn.projectmanager.com/tasks-teams#team-management)
- [Resource management](https://learn.projectmanager.com/resource-management#main-content)

    - [Resource Availability](https://learn.projectmanager.com/resource-management#resource-availability)
    - [Time Management](https://learn.projectmanager.com/resource-management#time-management)
- [Dashboards, reports & PPM](https://learn.projectmanager.com/dashboards-reports-ppm#main-content)

    - [Dashboards](https://learn.projectmanager.com/dashboards-reports-ppm#dashboards)
    - [Project Portfolio Management](https://learn.projectmanager.com/dashboards-reports-ppm#project-portfolio-management)
    - [Reports](https://learn.projectmanager.com/dashboards-reports-ppm#reports)
- [Account, security & users](https://learn.projectmanager.com/account-security-users#main-content)

    - [Account and Project Security](https://learn.projectmanager.com/account-security-users#account-and-project-security)
    - [User Management](https://learn.projectmanager.com/account-security-users#user-management)
    - [Account Management](https://learn.projectmanager.com/account-security-users#account-management)
- [Integrations](https://learn.projectmanager.com/integrations#main-content)

    - [AI](https://learn.projectmanager.com/integrations#ai)
    - [ERP / Accounting](https://learn.projectmanager.com/integrations#erp-accounting)
    - [Collaboration](https://learn.projectmanager.com/integrations#collaboration)
    - [Development](https://learn.projectmanager.com/integrations#development)
    - [Analytics](https://learn.projectmanager.com/integrations#analytics)
    - [API](https://learn.projectmanager.com/integrations#api)
- [Customer resources](https://learn.projectmanager.com/customer-resources#main-content)

    - [Training Academy](https://learn.projectmanager.com/customer-resources#training-academy)
    - [Listen & Learn Videos](https://learn.projectmanager.com/customer-resources#listen-learn-videos)
    - [Additional Languages](https://learn.projectmanager.com/customer-resources#additional-languages)
- [By industry](https://learn.projectmanager.com/by-industry#main-content)

    - [Construction](https://learn.projectmanager.com/by-industry#construction)
    - [Manufacturing](https://learn.projectmanager.com/by-industry#manufacturing)
    - [Professional Services](https://learn.projectmanager.com/by-industry#professional-services)
- [Latest releases](https://learn.projectmanager.com/latest-releases#main-content)

    - [Phased Releases](https://learn.projectmanager.com/latest-releases#phased-releases)
    - [2026 Releases](https://learn.projectmanager.com/latest-releases#2026-releases)
    - [2025 Releases](https://learn.projectmanager.com/latest-releases#2025-releases)
    - [2024 Releases](https://learn.projectmanager.com/latest-releases#2024-releases)
    - [2023 Releases](https://learn.projectmanager.com/latest-releases#2023-releases)
    - [2022 Releases](https://learn.projectmanager.com/latest-releases#2022-releases)
- [Mobile app](https://learn.projectmanager.com/mobile-app)

[![2022-PM-Logo-cropped](https://learn.projectmanager.com/hs-fs/hubfs/2022-PM-Logo-cropped.png?width=150&height=30&name=2022-PM-Logo-cropped.png "2022-PM-Logo-cropped")](https://www.projectmanager.com)

Get organized. Do amazing things.

<https://www.youtube.com/user/projectmanagervideos/videos> <https://www.linkedin.com/company/projectmanager.com/> <https://www.facebook.com/projectmanage/> <https://twitter.com/ProjectTips> [mailto:support@projectmanager.com](mailto:support@projectmanager.com)

[Login](https://software.projectmanager.com/login)  |  [Ask a Question](https://learn.projectmanager.com/kb-tickets/new)  |  [Tutorial Videos](https://www.projectmanager.com/product-videos)