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
John-project's avatar
John-project
Silver Contributor
Sep 11, 2024
Gongi1625,
I can't help you with PowerB1 but I do have several VBA macros that export Project data to Excel. Are there specific Project fields you want to export?

JOHN
  • 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