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

Steven de Hoog's avatar
Steven de Hoog
Copper Contributor
Jul 09, 2020

AdirondacksMy first thought would be to check the reporting granularity in PWA settings - Enterprise Data - Reporting.

If that's still set at weekly, you would get duplicate records after this change. Setting it to daily should solve the issue.

Resources