Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

MS Project Online template for Power Bi Changes

Hi guys,   I have connected Power BI with MS Project Online using the MS template file. All is working well data for Program / Project / Task / ... data can be querried. However the table for the C...
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    Thanks. I found the answer by myself 🙂 What is call in the MS Project Online Frontend "Changes" can be found in the table msdyn_projecthistory !

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Thanks. I found the answer by myself 🙂 What is call in the MS Project Online Frontend "Changes" can be found in the table msdyn_projecthistory !

christinepayton's avatar
christinepayton
Most Valuable Professional
1 year ago

Were you actually able to connect to the history table in Power BI? When I tried I believe the "elastic" type tables (which the project history table was, iirc, but the rest were not) wouldn't show up and gave an error when I navigated by schema name in PBI. But if you found a way to make it work I'd love to hear 🙂

 

Or wait Project Online. Proj Online is SharePoint, yes? Maybe I'm in the wrong thread, I was looking for the Planner for the Web / Dataverse connection for history. 

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi yes you can find this data in the table msdyn_projecthistory, but it is a bit cryptic. Because e.g. if the user check a milestone in the ToDo List you can only find IDs there not the caption.

     You can use this M scipt...
    let
    Source = Cds.Entities(#"Environment URL", [ReorderColumns=null, UseFormattedValue=null]),
    entities = Source{[Group="entities"]}[Data],
    msdyn_projecthistory = entities{[EntitySetName="msdyn_projecthistory"]}[Data]
    in
    msdyn_projecthistory