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

Paul_Mather's avatar
Paul_Mather
MVP
Jul 09, 2020

Hi Sue Adirondacks ,

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

Paul

Resources