Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe 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.
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?
Solved! Go to 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.
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.
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?