Forum Discussion

pauleast's avatar
pauleast
Copper Contributor
Dec 05, 2019

Historic RAG

Hi Does anyone know a simple way to collect historic RAG statuses etc. from Project Online? We want to show month on month changes to statuses however all reporting is 'live' - help!:)   Thanks  ...
pauleast's avatar
pauleast
Copper Contributor

Thanks Paul_Mather  - really helpful. One question is there a way to gather from multiple lists into one list? The lists all sit on the individual project sites. I am trying to find a way round the fact that the PowerBI content pack for PWA only draws from native fields, not custom one.

 

Thanks again!

Paul

Paul_Mather's avatar
Paul_Mather
MVP
Dec 19, 2019

Hi pauleast ,

You could build a process to push the data from all Risks lists etc. into one central list on the PWA site etc. or better still push it to something like Azure SQL DB then report of the SQL Database. There are many example 3rd party tools out there from Project partners that do this. We typically push all of the PWA data into an Azure SQL database (project, tasks, assignment, project site list data etc.) into an Azure SQL database and report from that.

Paul

  • pauleast's avatar
    pauleast
    Copper Contributor
    Dec 20, 2019

    Hi Paul_Mather 

     

    Might be a little outside of my skill set! Guessing that means there isn't a way with Flow to do this:(

     

    Appreciate your help!:)

    • Paul_Mather's avatar
      Paul_Mather
      MVP
      Dec 20, 2019

      Hi pauleast ,

      Yes you probably can do it with Flow - but you would need to build it 🙂

      Paul

Resources