Project Online & Power BI - Issue with Task's Resource Names vs Assignment's Resource Name

%3CLINGO-SUB%20id%3D%22lingo-sub-2740543%22%20slang%3D%22en-US%22%3EProject%20Online%20%26amp%3B%20Power%20BI%20-%20Issue%20with%20Task's%20Resource%20Names%20vs%20Assignment's%20Resource%20Name%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2740543%22%20slang%3D%22en-US%22%3E%3CP%20class%3D%22%22%3EHi!%3C%2FP%3E%3CP%20class%3D%22%22%3E%26nbsp%3B%3C%2FP%3E%3CP%20class%3D%22%22%3EI%20hope%20you%20are%20all%20fine.%3C%2FP%3E%3CP%20class%3D%22%22%3EI%20have%20the%20following%20issue%3A%20I%20connect%20to%20our%20company's%20Project%20Online%20through%20Odata%20in%20Power%20BI%20Desktop%20to%20retrieve%20Projects%2C%20Tasks%20and%20Assignments%20to%20build%20a%20customized%20report.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%20class%3D%22%22%3EIf%20it%20helps%3A%3C%2FP%3E%3CUL%3E%3CLI%3E%3CP%3EPower%20BI%20Desktop%3A%20Version%3A%202.96.1061.0%2064-bit%20August%202021%3C%2FP%3E%3C%2FLI%3E%3CLI%3E%3CP%3EProject%20Online%3A%20for%20now%20I%20use%20the%20web%20version%20to%20check%20some%20data%20until%20I%20get%20permission%20to%20use%20the%20Desktop%20Client%3C%2FP%3E%3C%2FLI%3E%3C%2FUL%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20issue%20is%20the%20following%20(simplified%20example)%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CUL%3E%3CLI%3E%3CP%3EProject%20Online%20shows%20a%20certain%20task%20%22Task%201%22%20with%20%22Resource%20Names%22%20column%20as%3A%20John%3B%20Silver%3B%20Leyla%3C%2FP%3E%3C%2FLI%3E%3CLI%3E%3CP%3EBut%20in%20Power%20Bi%2C%20Assignments%20table%20shows%203%20rows%20with%20the%20following%20info%20in%20%22Resource%20Name%22%3A%3C%2FP%3E%3CUL%3E%3CLI%3E%3CP%3ETask%201%2C%20Assignment%201%3AJohn%20(ok)%3C%2FP%3E%3C%2FLI%3E%3CLI%3E%3CP%3ETask%201%2C%20Assignment%202%3A%20Generic%20Local%20Resource%20(not%20ok%20or%20at%20least%2C%20not%20consistent)%3C%2FP%3E%3C%2FLI%3E%3CLI%3E%3CP%3ETask%201%2C%20Assignment%203%3A%20Leyla%20(ok)%3C%2FP%3E%3C%2FLI%3E%3C%2FUL%3E%3C%2FLI%3E%3C%2FUL%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFormerly%2C%20Silver%20appeared%20as%20Resource%20Name%20for%20Task1%2C%20Assignment%202%20in%20the%20Assignments%20table%2C%20but%20he%20left%20the%20company%20some%20months%20ago%20and%20after%20that%2C%20this%20discrepancy%20appeared.%3C%2FP%3E%3CP%3EProject%20Online%20keeps%20on%20showing%20him%20in%20the%20%22Resource%20Names%22%20column%20but%20not%20in%20the%20Assignments%20table%20imported%20to%20Power%20BI%2C%20which%20is%20a%20problem%20for%20my%20report.%3C%2FP%3E%3CP%3EMoreover%2C%20the%20%22Resource%20Names%22%20column%20doesn't%20come%20in%20the%20imported%20Tasks%20table.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20this%20a%20common%20issue%3F%20Is%20there%20any%20way%20to%20fix%20this%20or%20to%20work%20around%20it%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%20class%3D%22%22%3EThanks%20a%20lot!%3C%2FP%3E%3CP%20class%3D%22%22%3E%26nbsp%3B%3C%2FP%3E%3CP%20class%3D%22%22%3EGaby%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hi!

 

I hope you are all fine.

I have the following issue: I connect to our company's Project Online through Odata in Power BI Desktop to retrieve Projects, Tasks and Assignments to build a customized report.

 

If it helps:

  • Power BI Desktop: Version: 2.96.1061.0 64-bit August 2021

  • Project Online: for now I use the web version to check some data until I get permission to use the Desktop Client

 

The issue is the following (simplified example):

 

  • Project Online shows a certain task "Task 1" with "Resource Names" column as: John; Silver; Leyla

  • But in Power Bi, Assignments table shows 3 rows with the following info in "Resource Name":

    • Task 1, Assignment 1:John (ok)

    • Task 1, Assignment 2: Generic Local Resource (not ok or at least, not consistent)

    • Task 1, Assignment 3: Leyla (ok)

 

Formerly, Silver appeared as Resource Name for Task1, Assignment 2 in the Assignments table, but he left the company some months ago and after that, this discrepancy appeared.

Project Online keeps on showing him in the "Resource Names" column but not in the Assignments table imported to Power BI, which is a problem for my report.

Moreover, the "Resource Names" column doesn't come in the imported Tasks table.

 

Is this a common issue? Is there any way to fix this or to work around it?

 

Thanks a lot!

 

Gaby

0 Replies