Others

How to Fix Resource Name Differences Between Project Online and Power BI

Elise WilliamsElise Williams Nov 3, 2026 869 views

Question details

The user is experiencing a discrepancy in task resource names between Project Online and Power BI reporting tables.

How to Fix Resource Name Differences Between Project Online and Power BI
Product
Project Online, Power BI
Device & OS
not provided
Scenario
Generating assignment reports in Power BI using data extracted from Project Online.
Observed behavior
Project Online displays a former employee as the task resource, whereas Power BI shows a generic local resource in the Assignments table.
Before you start

Ensure you have reporting access to both Project Online and the relevant Power BI datasets to audit historical resource records and OData feeds.

Solution 1Recommended

Review Historical Assignments and OData Entities

Identify the source of the discrepancy by auditing inactive resources and understanding OData reporting limitations.

Differences in resource names often occur because historical resource records, such as those of former employees, become inactive. When pulled through OData feeds, these inactive or historical assignments may default to generic local resources in Power BI's Assignment table.

1
Audit Project Online resources

Log in to Project Online, navigate to your project's Resource Center, and verify the status of the specific resources, noting any that are marked as inactive.

2
Check historical assignments

Review the specific task assignments in Project Online to see if the assigned user is a former employee with historical data records.

3
Review Power BI OData queries

Open your Power BI Desktop file, go to 'Transform Data' to open the Power Query Editor, and inspect the OData feed pulling the Assignments and Resources entities to see how inactive names are handled.

4
Consult the Microsoft Project Community

Because this involves specific Microsoft OData reporting limitations, visit the Microsoft Project Tech Community (https://techcommunity.microsoft.com/t5/project/bd-p/Project) to post your specific schema issue for specialized guidance.

Review Historical Assignments and OData Entities
Data Source Limitation: Power BI relies entirely on the data structure provided by the Project Online OData service. Modifying how inactive resources are mapped usually requires adjusting the underlying query or data model.
Free Microsoft Office alternative

Manage Your Projects Efficiently with WPS Office

While specialized tools like Project Online handle complex enterprise data structures, WPS Office offers a free, lightweight, and highly compatible alternative for everyday project tracking, resource management, and reporting.

  1. 1. Download the software: Visit the official WPS Office website and download the free installation package for your device.
  2. 2. Install and launch: Run the installer and follow the on-screen prompts to set up WPS Office on your computer.
  3. 3. Track your resources: Open WPS Spreadsheet, import your existing resource data or choose a project management template to start tracking assignments.
Highly compatible with Microsoft Excel (.xlsx) formats to seamlessly migrate your project data.Built-in spreadsheet templates for project tracking, Gantt charts, and resource management.Lightweight software that runs smoothly on Windows, Mac, Linux, and mobile devices.Familiar user interface requires no additional learning curve for new team members.
microsoft office alternative - wps office

Frequently Asked Questions

Why does Power BI show generic resources instead of named users from Project Online?

This commonly happens due to OData reporting limitations when a named user becomes an inactive resource (such as a former employee). The data export process may substitute the historical user with a generic local resource in the Assignments table.

How can I refresh my Power BI data to reflect recent Project Online changes?

In Power BI Desktop, click the 'Refresh' button on the Home ribbon. This will execute your queries and pull the latest available data from the Project Online OData feed.

Where can I get advanced help for Project Online and Power BI integration?

For specialized and complex reporting issues involving OData entities, it is highly recommended to post your queries in the official Microsoft Project Tech Community forum, where product experts can provide targeted advice.