• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
  • Skip to footer
Lydon Solutions

Lydon Solutions

Construction Project Management Software Solutions

  • Construction Viz
  • Services
    • Business Consulting
    • Professional Services
    • Microsoft 365 Managed Services
    • Government Agencies
  • Company
  • Events
  • Blog
  • Careers
  • Contact
  • Search
  • Free Consultation
Show Search
Hide Search
Jeff Lydon

Jeff Lydon, the president and founder of Lydon Solutions, has over 20 years of experience in construction project management, project controls, and product management across multiple industries, including civil/environmental, manufacturing, healthcare, and utilities.

Using Microsoft Power BI for Reporting with Project Online

December 7, 2021 How-To

More than likely, your organization uses the project-specific reports available out of the box with the Microsoft Project desktop application. But as your portfolio grows, you may need to move to Microsoft 365 Project Online. Project Online offers many advantages over the desktop version, including enterprise resources and codes, permissions management, project templates, and integration with the Microsoft 365 Power Platform. Unfortunately, you will quickly realize that there are no canned reports in Project Online like those you are familiar with in the desktop application. So, what do you do?

Using Microsoft Power BI to create Microsoft Project Online reports

The “official” reporting solution for Microsoft Project Online is Power BI. Power BI is another Microsoft 365 subscription. If you are going to build custom reports, you may want to have at least one Power BI Pro license. Note: Power BI Pro comes with a Microsoft 365 E5 subscription or is available for $9.99/user/month for an individual license.

Next, you will want to install the Microsoft Project add-in for Power BI, which you can download here. The add-in includes some key data fields from Project and some visually appealing pre-defined dashboard report templates.

Project Online Add-In for Power BI

WhereReports_1

So, you are all set to create your custom reports across your portfolio! Well, not exactly…

You will find out pretty quickly that if you want to create a “simple” report like a monthly resource cash flow across all your projects in Power BI, it is much more complicated than you would think. The good news is that Lydon Solutions has built several configurable Power BI solutions that can generate monthly expenditures for any resource or activity across your portfolio. The report can be further customized to your organization’s needs and added to Teams or SharePoint.

Project Online Cash Flow Report for Power BI

WhereReports_2

Get Help with Microsoft 365, Project Online, and Power BI

As you know, setting up a portfolio cashflow report in Microsoft Project Online is more than just building a report in Power BI. Lydon Solutions can assist you with everything from Microsoft 365 configuration to delivering custom Power BI reports so you can focus on managing your construction projects. You can find out more by requesting a free consultation here.

Reader Interactions


Related Posts

Microsoft Teams Bulletin App
How-To | February 2, 2023

Keep Your Team in the Loop with the Microsoft Teams Bulletins App

Read More >
ChatGPT Microsoft 365
Reviews | January 23, 2023

What Value Does Microsoft 365 Bring to an Organization? (According to ChatGPT)

Read More >
How-To | January 16, 2023

Microsoft 365 OneDrive and Teams for Your Construction PMIS

Read More >

Comments

  1. Paul Savage says

    August 4, 2022 at 10:01 am

    What licenses are required for users consuming reports that have data pulled from Project Online?

    Is this considered Multiplexing? Do the consumers just require a Power BI Pro license?

Primary Sidebar

Search Blog

Recent Posts

Microsoft Teams Bulletin App
How-To | February 2, 2023

Keep Your Team in the Loop with the Microsoft Teams Bulletins App

ChatGPT Microsoft 365
Reviews | January 23, 2023

What Value Does Microsoft 365 Bring to an Organization? (According to ChatGPT)

How-To | January 16, 2023

Microsoft 365 OneDrive and Teams for Your Construction PMIS

How-To | January 6, 2023

What Microsoft 365 @mentions Mean for Construction Communications

Microsoft News | December 13, 2022

How to use Microsoft Teams Updates for Construction

Tips from the Field | November 21, 2022

Tips from the Field: Adding Images to a Power BI Report

Footer

About

Lydon Solutions is a WBE consulting group specializing in construction project management software solutions using Microsoft SharePoint. Learn more >

Products & Services

  • Construction Viz
  • Professional Services
  • Business Consulting
  • Microsoft 365 Managed Services
  • Government Agencies

News & Events

  • Events
  • Blog

Company

  • About
  • Careers
  • Contact Us

Join our Mailing List

  • This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.
  • This field is for validation purposes and should be left unchanged.
Lydon Solutions

© Lydon Solutions

  • Sitemap
  • Privacy
  • Cookies
  • Terms of Use
  • Disclaimer