How to get custom columns from Project for the Web?

[vietna]

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?

[Anonymous · Accepted solution]

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.

[Anonymous]

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?

[Anonymous]

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