How to Fix Resource Name Differences Between Project Online and Power BI
Question details
The user is experiencing a discrepancy in task resource names between Project Online and Power BI reporting tables.

- 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.
Ensure you have reporting access to both Project Online and the relevant Power BI datasets to audit historical resource records and OData feeds.
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.
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.
Review the specific task assignments in Project Online to see if the assigned user is a former employee with historical data records.
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.
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.

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. Download the software: Visit the official WPS Office website and download the free installation package for your device.
- 2. Install and launch: Run the installer and follow the on-screen prompts to set up WPS Office on your computer.
- 3. Track your resources: Open WPS Spreadsheet, import your existing resource data or choose a project management template to start tracking assignments.

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.




