How to Connect Microsoft Project to Power BI

Your Microsoft Project plan holds a goldmine of data about tasks, timelines, resources, and dependencies, but its built-in reports can be limiting. To get a truly dynamic and shareable view of your project's health, connecting it to a powerful business intelligence tool is the way to go. This guide will walk you through exactly how to connect Microsoft Project to Power BI to build custom, interactive project dashboards.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Why Connect Microsoft Project to Power BI?

Before jumping into the how-to, it’s worth understanding the payoff. Manually screenshotting Gantt charts or emailing static PDF reports is a thing of the past. Connecting MS Project to Power BI unlocks a new level of project reporting that offers several advantages:

• Fully Interactive Dashboards: Instead of a flat report, Power BI allows you to create dashboards where stakeholders can click, filter, and drill down into the data themselves. They can isolate tasks by resource, filter by completion status, or view a specific date range, all in real-time.
• Consolidated Data from Multiple Sources: A project's success is tied to more than just task completion. With Power BI, you can pull your MS Project data into the same report as your financial data from QuickBooks, sales data from Salesforce, or marketing data from Google Analytics. This gives you a complete, 360-degree view of how your project impacts the entire business.
• Superior Visualizations: Power BI offers a vast library of charts, graphs, and custom visuals that go far beyond what MS Project offers. You can create donut charts for task status, waterfall charts for budget burn-down, or detailed KPI cards to highlight critical metrics at a glance.
• Automation and Scalability: Once the connection is set up, refreshing your dashboard with the latest project data is as simple as clicking a button or setting up a scheduled refresh. No more rebuilding reports from scratch every week.

Before You Begin: What You'll Need

To make this process as smooth as possible, make sure you have the following ready:

• Your Microsoft Project File (.mpp): Have your project file saved and easily accessible. We'll be focusing primarily on connecting local .mpp files, which is the most common scenario for many project managers.
• Power BI Desktop: This tutorial uses Power BI Desktop, the free authoring tool from Microsoft. If you don't have it installed, you can download it for free from the Microsoft Store.
• A Clear Goal: Know what you want to visualize. Are you tracking overdue tasks? Monitoring resource allocation? Showcase budget vs. actuals? Having a few key performance indicators (KPIs) in mind will make the dashboard-building process much more focused.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Step-by-Step Guide: Connecting Your Local .MPP File to Power BI

While Power BI offers a direct connector for Project Online, connecting a standard, local .mpp file requires a simple extra step for the best results. The most reliable method is to first export your project data as an XML file, a universal format that Power BI loves. Let's walk through it.

Step 1: Export Your Data from Microsoft Project

First, you need to get your project data out of MS Project's proprietary format and into a structured file that Power BI can easily read. XML is perfect for this.

1. Open your project plan in Microsoft Project.
2. Go to File > Save As.
3. Choose a location to save your file.
4. In the "Save as type" dropdown menu, select XML (*.xml).
5. Click Save.

That's it. You now have a clean, structured XML file containing all your project's tables, including Tasks, Resources, and Assignments.

Step 2: Connect Power BI to the Exported XML File

Now, let’s open Power BI and pull that data in.

1. Launch Power BI Desktop.
2. On the Home ribbon, click Get Data. If you don't see the XML option, click More...
3. In the Get Data window, select XML from the list (you can find it in the "File" or "All" category). Click Connect.
4. Navigate to where you saved your XML file in the previous step, select it, and click Open.
5. Power BI will now display a Navigator window. This shows you all the distinct tables of data inside the XML file. You'll see things like Project, Resource, Task, and Assignment. For most project dashboards, the Task table is the most important one.
6. Select the checkbox next to the Task table. You’ll see a preview of the data on the right.
7. Instead of clicking "Load," click Transform Data. This is crucial, as it opens the Power Query Editor, where you'll clean and prepare your data for analysis.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Step 3: Clean and Prepare Your Data in Power Query

Welcome to the Power Query Editor. This is your data workshop. It's where you refine the raw data from MS Project into something clean and usable for your dashboard. Your exported project data will have dozens of columns — many of which you don't need.

Tidy Up Your Columns

• Remove Unneeded Columns: This is the most important first step. Your Task table might have over 100 columns. Hold down the CTRL key and select the columns you actually want to use. Common choices include: UID, Name, Start, Finish, PercentComplete, Work, Duration, ResourceNames. Once you have your desired columns selected, right-click on any of the selected column headers and choose Remove Other Columns.
• Rename Columns for Clarity: Some column names might not be intuitive. You can double-click any column header to rename it (e.g., rename PercentComplete to % Complete).

Adjust Data Types

Power BI often tries to guess the data type for each column, but it's good practice to verify them.

• Click the small icon on the left side of each column header to set its type.
• Ensure your Start and Finish columns are set to the Date/Time or Date data type.
• Set % Complete to a Percentage. You can do this by first changing the type to Decimal Number, then selecting the column and using the "Format" dropdown on the toolbar to select "Percentage."
• Set numerical columns like Work or Duration to Decimal Number or Whole Number.

Create Custom Columns

This is where you can add real value to your report. You can create new columns based on existing data. Go to the Add Column tab and click Custom Column.

Here’s a useful example: a "Task Status" column.

if [PercentComplete] = 1 then "Completed"
else if [Start] > DateTime.LocalNow() then "Not Started"
else "In Progress"

Once you are finished cleaning and transforming, click the Close & Apply button on the top-left of the Home ribbon. Power BI will load your clean data model, and you'll be ready to start building your dashboard.

Step 4: Build Your Project Dashboard Visuals

You're now on the blank canvas of your Power BI report. Let's create a few common and useful visuals for a project dashboard.

• Project KPIs: From the Visualizations pane, select the Card visual. Drag a measure like % Complete into the Fields well and set its aggregation to Average. Create another card and drag the task Name in, setting its aggregation to Count to get a total task count.
• Task Status Donut Chart: Select the Donut chart visual. Drag your custom "Task Status" column to the Legend and the task Name (or UID) to the Values well (make sure it's set to "Count"). This gives you an excellent at-a-glance view of your project's progress.
• Gantt Chart: Power BI doesn't have a native Gantt chart, but you can add a fantastic one for free. In the Visualizations pane, click the three dots (...) and select Get more visuals. Search for "Gantt" and add the one by Microsoft. Once it’s added to your pane, select it, and then drag Name to the Task field, Start to the Start Date field, Finish to the End Date field, and % Complete to the % Completion field.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Using Power BI with Project Online or Project for the Web

If your organization uses Microsoft's cloud-based project management tools, the connection process is much more direct. You don't need to export anything manually.

1. In Power BI Desktop, click Get Data > More...
2. Choose Online Services, search for Project Online, and click Connect.
3. You'll be prompted to enter the URL for your Project Web App site. For Project for the Web, you enter your Dataverse Environment URL.
4. Click OK, and you’ll see the same Navigator experience, allowing you to select project tables like you did with the XML file.

This method has the added benefit of being easier to set up for scheduled refreshes, since the data is already in the cloud.

Final Thoughts

Connecting Microsoft Project to Power BI is a fantastic way to transform static project plans into dynamic, analytical resources. By following these steps, you can create customized, shareable dashboards that provide clear insights and help your team and stakeholders make better, more informed decisions about project health.

This process gives you total control over your project reporting, but we know first-hand that getting data from different tools into one place can still be a pain. Between exporting files, managing API connections, and setting up data pipelines, it often takes hours just to get your sources connected. We built Graphed to remove that friction completely. We connect natively to your key marketing and sales platforms, and you simply ask for the dashboard you need in plain English. Your KPIs are streamed in automatically, giving you a live view of business performance without the manual setup.