Forum Discussion

Adirondacks's avatar
Adirondacks
Copper Contributor
Jul 08, 2020
Solved

change time recording from weekly to daily in project online

Hi Our company has just changed the timesheet capture from weekly to daily, and now the timesheet report in PowerBI doesn't work. It says there is duplicate data in an Assignment field. Any ideas?
  • Paul_Mather's avatar
    Paul_Mather
    Jul 09, 2020

    Hi Sue Adirondacks ,

    Try changing the relationship for one to many  - one from TimesheetLines to many TimesheetLineActuals

    Paul

Adirondacks's avatar
Adirondacks
Copper Contributor
Jul 09, 2020

Hi Paul Paul_Mather 

 

Here is a snapshot of the data model

Adirondacks's avatar
Adirondacks
Copper Contributor
Jul 10, 2020

Paul_Mather 

 

Hi Paul all working now thanks!

 

Sue 

  • Paul_Mather's avatar
    Paul_Mather
    MVP
    Jul 10, 2020

    That's good, thanks Sue Adirondacks 

    Would you mind marking my reply as the best answer to help others with a similar issue?

    Thanks

    Paul

Resources