With Power BI Connected to Project Online, How to Retrieve Custom Columns from the Schedule

[maibacher]

Hello, today I'm very happy to have connected a BI report directly to my project schedule located in my Project Center for the first time. But there's just one major problem, which is that the query doesn't bring in the custom columns that my team established.

For example, the query pulls in the task name (probably because task name is a standard column). But the query does NOT bring in team name (probably because my team establish this as a custom column).

My report MUST have team names included. Does anyone have experience or advice to share on how to solve this?

MANY THANKS.

Dan

(Side note but I am using my Microsoft partner account to post this; I am not a Microsoft employee as my username/avatar suggests).

[maibacher]

Hi , thanks so much for your reply. I concur that the project schedule data is in the Tasks table, but the are zero custom columns brought into my model. Neither does "Team" appear in the list of columns nor does the custom category name appear (as we are not actually labeling it "team").

And to confirm, I am looking at the query prior to the removal of other extranneous columns.

My source and navigation steps go as follows:

Source = OData.Feed("https:nameofsite.sharepoint.com/sites/pwa/_api/ProjectData/[en-us]", null, [Implementation="2.0"]),
Tasks_table = Source{[Name="Tasks",Signature="table"]}[Data],

Thanks again,

Dan

[collinq]

Hi @maibacher ,

Try this in the advanced editor:

Source = OData.Feed("https:nameofsite.sharepoint.com/sites/pwa/_api/ProjectData/[en-us]"), 
Tasks_table = Source{[Name="Tasks",Signature="table"]}[Data],

[maibacher · Accepted solution]

Hi @collinq , I was able to determine that the field in the schedule, though custom, is local to the .pbix file. Only enterprise fields are available to the Power BI query when connected to Project Online. My next task is to build the new enterprise field in the schedule file, populate it, and republish.

I appreciate you looked into this!

[maibacher]

Thanks again! I followed along your advice and swapped your variant for the source step, and although this still produced the schedule data table successfully, the columns available are no different from before. I'm very intrigued about the possibilities at the source step all the same.

Many thanks, I'd love to hear any further suggestions.

[collinq]

Hi @maibacher ,

When connecting Power BI to Project and pulling back a project file the custom fields are listed in the list of available fields.  If Team Name is at task level, the field will appear inthe Tasks table.  Like this example, the first two fields I have are custom fields in the Tasks table.