Forum Discussion
Microsoft EmployeeWith Power BI Connected to Project Online, How to Retrieve Custom Columns from the Schedule
Hello, today I'm very happy to have connected a BI report directly to my project schedule located in my Project Center for the first time. But there's just one major problem, which is that the query doesn't bring in the custom columns that my team established.
For example, the query pulls in the task name (probably because task name is a standard column). But the query does NOT bring in team name (probably because my team establish this as a custom column).
My report MUST have team names included. Does anyone have experience or advice to share on how to solve this?
MANY THANKS.
Dan
(Side note but I am using my Microsoft partner account to post this; I am not a Microsoft employee as my username/avatar suggests).
Hi collinq , I was able to determine that the field in the schedule, though custom, is local to the .pbix file. Only enterprise fields are available to the Power BI query when connected to Project Online. My next task is to build the new enterprise field in the schedule file, populate it, and republish.
I appreciate you looked into this!
