Forum Discussion

Gongi1625's avatar
Gongi1625
Copper Contributor
Sep 11, 2024

History export

Hi, I’m trying to create a report in Power BI or Excel with the history of tasks for the entire project. We have options to track the history of each task, but I would like to see the history as one...
Project
Gongi1625's avatar
Gongi1625
Copper Contributor
Sep 12, 2024

Hi John-project,

 

I would like to create complete log from history of task. So Export all changes in task history in one place. See attached picture, maybe it will be more clear. In theory it is stored in Dataverse in the Project History table.

 

Gongi

malshayeb's avatar
malshayeb
Brass Contributor
Sep 12, 2024

Gongi1625 

Hi,

You are correct that data is stored in the project history, and in theory you should be able to report on it, the challenge you will face is, this is not a reporting table so the details of the change are not presented in a format that you can use directly.

in the table you will find everything you need to create the report 

  • The project 
  • The task 
  • The edit Type 
  • the timestamp 

however the details of the change or what changed are stored in a field called details an example below 

 

{"fields":{"start":{"previous":"","updated":"2024-09-12T09:00:00Z"}}}

 

I believe that is Jason and you need to work on it within PowerBI to convert it. 

 

Resources