MS Project Online template for Power Bi Changes

[MartinGeschke]

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 Changes msdyn_projectchanges is empty.

Do somebody have experience with it? I'm looking for the data from the screenshot...

[v-jiewu-msft]

Hi @MartinGeschke ,

Based on the information, try to verify that the data in power bi has been refreshed.

You can view the following documents to learn more information.

Connect to Project Online with Power BI - Power BI | Microsoft Learn

Use Power BI Desktop to connect with your Project data - Microsoft Support

Project Online: connect to data through Power BI Desktop - Power BI | Microsoft Learn

Solved: With Power BI Connected to Project Online, How to ... - Microsoft Fabric Community

Best Regards,

Wisdom Wu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[MartinGeschke · Accepted solution]

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]

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. 

[MartinGeschke]

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

[KKirby]

Are you trying to connct to Project Online or Project Planner data?  Either you have the wrong template or you're using the Projct Online PBI template to try and connct to Project Planner data. Don't confuse Project Online with Project Planner... the former is NOT stored in Dataverse, the latter is. And the table you refer to is a Dataverse table!