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_Mather 

this is Sue Thomas in case you didn't see that! So i have checked the PWA Reporting settings and they are now set to daily. This is a custom report looking at Date, Task Name, Resource and Timesheet Owner name and number of hrs logged. The data source error is below. It was working fine until we changed to enabling folk to log time per day.

 

Data source errorColumn 'TimesheetLineId' in Table 'TimesheetLineActualDataSet' contains a duplicate value '<pii>4fd6d662-6bc0-ea11-b09c-00155d088804</pii>' and this is not allowed for columns on the one side of a many-to-one relationship or for columns that are used as the primary key of a table. Table: TimesheetLineActualDataSet.

 

Sue

Paul_Mather's avatar
Paul_Mather
MVP
Jul 09, 2020

Hi Sue! Adirondacks,

This is going to be an issue with the data model in the customer Power BI report - what relationships are there on the TimesheetLineActualDataSet table in Power BI? This might be tricky to resolve over a forum like this.

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

    • 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