Microsoft Project Plan 3 Custom Column Data in Power BI Desktop

[asw]

Good Day

I would appreciate some help please to access Project Plan 3 custom fields in Power BI desktop.  Underneath some explanation & examples.

I have created various different custom fields, in different projects, using MS Project Plan 3.  Underneath is one such field named "Reason Task Was Late" with a test entry.

I also download the following templates from github

Using "Project for the Web" and "Project" templates I managed to setup/connect and refresh the reports, all importing the relevant project data.  

The only problem I have is the data from the custom fields.  These are not reflecting in the reports.

Could you please guide me where to look for the data (table and fields) and/or the steps I need to follow include the data in the reports.

Thank you

Kind regards

Stephan Willemse

[Anonymous · Accepted solution]

Hi @asw ,

Based on test, default project connector can't access to custom fields.

You can try to use odata connector with project online rest api to get custom fields.

Related link:

https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-connect-odata

At the same time, this post has the same issue as your, may be it can provide useful information to you:

project online custom fields - Microsoft Power BI Community

Best regards,

Community Support Team Selina zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.