How to get custom columns from Project for the Web?

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.