Forum Discussion
MS Project Online template for Power Bi Changes
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 !
Hi Anonymous ,
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.
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 !
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.
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
