How to get custom columns from Project for the Web?

vietna — Wed, 16 Mar 2022 08:25:36 GMT

I'm working on a dashboard based on Project for web plans and I need to get data from custom columns but I don't see how to access from Power bi, any idea?

Re: How to get custom columns from Project for the Web?

Anonymous — Mon, 21 Mar 2022 06:40:44 GMT

Hi @vietna ,

I think you can try Web connector to achieve your goal.

Here is an article I ran across detailing how to include the Enterprise Custom Fields (ECF) inside Power BI via the pre-built Power BI to Project Online PBI file.

Extending the PowerBI content pack for Project on the web

Example:

Source = Xml.Tables(Web.Contents("https://[yourtenant].sharepoint.com/sites/[yoursite]/_api/ProjectServer/Projects?" & "$expand=Tasks&$select=Id" & ",Tasks/Id" & ",Tasks/OutlineLevel" & ",Tasks/OutlinePosition" & ",Tasks/Name" & ",Tasks/Start" & ",Tasks/Finish" & ",Tasks/ActualStart" & ",Tasks/ActualFinish" & ",Tasks/PercentComplete" & ",Tasks/PercentPhysicalWorkComplete" & ",Tasks/Duration" & ",Tasks/RemainingDuration" & ",Tasks/Work" & ",Tasks/Cost" & ",Tasks/IsActive" & ",Tasks/Custom_x005f_90eaefb93561e911afb900155d0c3815" & ",Tasks/Custom_x005f_1a9572776960e9119487283a4d07a952" & ",Tasks/Custom_x005f_351797c94968e911b07700155d10a106" & ",Tasks/Custom_x005f_c4f66ed64968e911b07700155d10a106" & ",Tasks/Custom_x005f_d3dfad7fa85fe911afb800155d10502b"))

Notice the Tasks/Custom_x005f_xxxxxxxx. Those are enterprise custom field lookup entries associated with that task. You can pull their values from the Enterprise Lookup tables and relate them in Power BI.

For reference: project online custom fields

Best Regards,
Rico Zhou

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

Re: How to get custom columns from Project for the Web?

Anonymous — Mon, 27 Feb 2023 10:57:00 GMT

Hello,

The solution you mentioned is for Project Online and not for Project for the Web right? Any ways to import the custom columns in PowerBI from Project for the Web?

Re: How to get custom columns from Project for the Web?

Anonymous — Mon, 20 Nov 2023 11:53:55 GMT

any hint, how to access custom project for the web fields into power bi?

topic Re: How to get custom columns from Project for the Web? in Developer

How to get custom columns from Project for the Web?

Re: How to get custom columns from Project for the Web?

Re: How to get custom columns from Project for the Web?

Re: How to get custom columns from Project for the Web?