Forum Discussion

maibacher's avatar
maibacher
Icon for Microsoft Employee rankMicrosoft Employee
5 years ago
Solved

With 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 ...
Need Help
  • maibacher's avatar
    maibacher
    5 years ago

    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!

maibacher's avatar
maibacher
Icon for Microsoft Employee rankMicrosoft Employee
5 years ago

Hi , thanks so much for your reply. I concur that the project schedule data is in the Tasks table, but the are zero custom columns brought into my model. Neither does "Team" appear in the list of columns nor does the custom category name appear (as we are not actually labeling it "team").

And to confirm, I am looking at the query prior to the removal of other extranneous columns.

My source and navigation steps go as follows:

Source = OData.Feed("https:nameofsite.sharepoint.com/sites/pwa/_api/ProjectData/[en-us]", null, [Implementation="2.0"]),
Tasks_table = Source{[Name="Tasks",Signature="table"]}[Data],

Thanks again,

Dan

  • collinq's avatar
    collinq
    Icon for Super User rankSuper User
    5 years ago

    Hi maibacher ,

     

    Try this in the advanced editor:

    Source = OData.Feed("https:nameofsite.sharepoint.com/sites/pwa/_api/ProjectData/[en-us]"), 
    Tasks_table = Source{[Name="Tasks",Signature="table"]}[Data],

    • maibacher's avatar
      maibacher
      Icon for Microsoft Employee rankMicrosoft Employee
      5 years ago

      Thanks again! I followed along your advice and swapped your variant for the source step, and although this still produced the schedule data table successfully, the columns available are no different from before. I'm very intrigued about the possibilities at the source step all the same.

       

      Many thanks, I'd love to hear any further suggestions.

    • maibacher's avatar
      maibacher
      Icon for Microsoft Employee rankMicrosoft Employee
      5 years ago

      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!