Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
vietna
Frequent Visitor

How to get custom columns from Project for the Web?

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?

1 ACCEPTED SOLUTION
v-rzhou-msft
Community Support
Community Support

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.

 

View solution in original post

3 REPLIES 3
v-rzhou-msft
Community Support
Community Support

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
Not applicable

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
Not applicable

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

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!