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!

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.