SOLVED

change time recording from weekly to daily in project online

%3CLINGO-SUB%20id%3D%22lingo-sub-1508115%22%20slang%3D%22en-US%22%3Echange%20time%20recording%20from%20weekly%20to%20daily%20in%20project%20online%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1508115%22%20slang%3D%22en-US%22%3E%3CP%3EHi%3C%2FP%3E%3CP%3EOur%20company%20has%20just%20changed%20the%20timesheet%20capture%20from%20weekly%20to%20daily%2C%20and%20now%20the%20timesheet%20report%20in%20PowerBI%20doesn't%20work.%20It%20says%20there%20is%20duplicate%20data%20in%20an%20Assignment%20field.%20Any%20ideas%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1510771%22%20slang%3D%22en-US%22%3ERe%3A%20change%20time%20recording%20from%20weekly%20to%20daily%20in%20project%20online%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1510771%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F721953%22%20target%3D%22_blank%22%3E%40Adirondacks%3C%2FA%3EMy%20first%20thought%20would%20be%20to%20check%20the%20reporting%20granularity%20in%20PWA%20settings%20-%20Enterprise%20Data%20-%20Reporting.%3C%2FP%3E%3CP%3EIf%20that's%20still%20set%20at%20weekly%2C%20you%20would%20get%20duplicate%20records%20after%20this%20change.%20Setting%20it%20to%20daily%20should%20solve%20the%20issue.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1511172%22%20slang%3D%22en-US%22%3ERe%3A%20change%20time%20recording%20from%20weekly%20to%20daily%20in%20project%20online%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1511172%22%20slang%3D%22en-US%22%3E%3CP%3EHello%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F721953%22%20target%3D%22_blank%22%3E%40Adirondacks%3C%2FA%3E%2C%3C%2FP%3E%0A%3CP%3EIs%20this%20a%20default%20Project%20Online%20Power%20BI%20Report%20pack%20or%20a%20custom%20one%20you%20have%20built%3F%20Which%20dataset%20%2F%20endpoint%20is%20Power%20BI%20complaining%20about%3F%20Does%20it%20detail%20the%20field%20name%20too%3F%20As%20mentioned%20in%20the%20post%20above%20-%20it%20is%20worth%20confirming%20that%20your%20PWA%20Reporting%20settings%20are%20set%20to%20daily%20if%20you%20are%20now%20needing%20to%20report%20on%20Task%20Timephased%20%2F%20Assignment%20Timephased%20data%20at%20the%20day%20level%20-%20this%20setting%20doesn't%20impact%20the%20timephased%20Timesheet%20Actuals%20data%20though.%26nbsp%3B%3C%2FP%3E%0A%3CP%3EPaul%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1511452%22%20slang%3D%22en-US%22%3ERe%3A%20change%20time%20recording%20from%20weekly%20to%20daily%20in%20project%20online%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1511452%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F8793%22%20target%3D%22_blank%22%3E%40Paul%20Mather%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ethis%20is%20Sue%20Thomas%20in%20case%20you%20didn't%20see%20that!%20So%20i%20have%20checked%20the%20PWA%20Reporting%20settings%20and%20they%20are%20now%20set%20to%20daily.%20This%20is%20a%20custom%20report%20looking%20at%20Date%2C%20Task%20Name%2C%20Resource%20and%20Timesheet%20Owner%20name%20and%20number%20of%20hrs%20logged.%20The%20data%20source%20error%20is%20below.%20It%20was%20working%20fine%20until%20we%20changed%20to%20enabling%20folk%20to%20log%20time%20per%20day.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22errorInfoLabel%22%3EData%20source%20error%3C%2FSPAN%3E%3CSPAN%20class%3D%22errorInfo%22%3EColumn%20'TimesheetLineId'%20in%20Table%20'TimesheetLineActualDataSet'%20contains%20a%20duplicate%20value%20'%3CPII%3E4fd6d662-6bc0-ea11-b09c-00155d088804%3C%2FPII%3E'%20and%20this%20is%20not%20allowed%20for%20columns%20on%20the%20one%20side%20of%20a%20many-to-one%20relationship%20or%20for%20columns%20that%20are%20used%20as%20the%20primary%20key%20of%20a%20table.%20Table%3A%20TimesheetLineActualDataSet.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22errorInfo%22%3ESue%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1511793%22%20slang%3D%22en-US%22%3ERe%3A%20change%20time%20recording%20from%20weekly%20to%20daily%20in%20project%20online%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1511793%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Sue!%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F721953%22%20target%3D%22_blank%22%3E%40Adirondacks%3C%2FA%3E%2C%3C%2FP%3E%0A%3CP%3EThis%20is%20going%20to%20be%20an%20issue%20with%20the%20data%20model%20in%20the%20customer%20Power%20BI%20report%20-%20what%20relationships%20are%20there%20on%20the%26nbsp%3B%3CSPAN%3ETimesheetLineActualDataSet%20table%20in%20Power%20BI%3F%20This%20might%20be%20tricky%20to%20resolve%20over%20a%20forum%20like%20this.%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%3EPaul%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1511994%22%20slang%3D%22en-US%22%3ERe%3A%20change%20time%20recording%20from%20weekly%20to%20daily%20in%20project%20online%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1511994%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Paul%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F8793%22%20target%3D%22_blank%22%3E%40Paul%20Mather%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHere%20is%20a%20snapshot%20of%20the%20data%20model%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1512378%22%20slang%3D%22en-US%22%3ERe%3A%20change%20time%20recording%20from%20weekly%20to%20daily%20in%20project%20online%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1512378%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Sue%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F721953%22%20target%3D%22_blank%22%3E%40Adirondacks%3C%2FA%3E%26nbsp%3B%2C%3C%2FP%3E%0A%3CP%3ETry%20changing%20the%20relationship%20for%26nbsp%3Bone%20to%20many%26nbsp%3B%20-%20one%20from%20TimesheetLines%20to%20many%20TimesheetLineActuals%3C%2FP%3E%0A%3CP%3EPaul%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1514721%22%20slang%3D%22en-US%22%3ERe%3A%20change%20time%20recording%20from%20weekly%20to%20daily%20in%20project%20online%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1514721%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F8793%22%20target%3D%22_blank%22%3E%40Paul%20Mather%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%20Paul%20all%20working%20now%20thanks!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESue%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1514838%22%20slang%3D%22en-US%22%3ERe%3A%20change%20time%20recording%20from%20weekly%20to%20daily%20in%20project%20online%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1514838%22%20slang%3D%22en-US%22%3E%3CP%3EThat's%20good%2C%20thanks%20Sue%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F721953%22%20target%3D%22_blank%22%3E%40Adirondacks%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EWould%20you%20mind%20marking%20my%20reply%20as%20the%20best%20answer%20to%20help%20others%20with%20a%20similar%20issue%3F%3C%2FP%3E%0A%3CP%3EThanks%3C%2FP%3E%0A%3CP%3EPaul%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1514857%22%20slang%3D%22en-US%22%3ERe%3A%20change%20time%20recording%20from%20weekly%20to%20daily%20in%20project%20online%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1514857%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F8793%22%20target%3D%22_blank%22%3E%40Paul%20Mather%3C%2FA%3E%26nbsp%3B%20done%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

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?

9 Replies

@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.

Hello @Adirondacks,

Is this a default Project Online Power BI Report pack or a custom one you have built? Which dataset / endpoint is Power BI complaining about? Does it detail the field name too? As mentioned in the post above - it is worth confirming that your PWA Reporting settings are set to daily if you are now needing to report on Task Timephased / Assignment Timephased data at the day level - this setting doesn't impact the timephased Timesheet Actuals data though. 

Paul 

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

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

Hi Paul @Paul Mather 

 

Here is a snapshot of the data model

best response confirmed by Adirondacks (Occasional Contributor)
Solution

Hi Sue @Adirondacks ,

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

Paul

@Paul Mather 

 

Hi Paul all working now thanks!

 

Sue 

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