Forum Discussion
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 Changes msdyn_projectchanges is empty.
Do somebody have experience with it? I'm looking for the data from the screenshot...
5 Replies
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!
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.
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.
