Sue has attended:
Power BI Modelling, Visualisation and Publishing course
Power BI Reporting course
PowerBI and Project Online
I had created a report in Powerbi that allowed me to report on Project Online Timesheets. Initially our company was tracking time at the Week level. Now they have changed the config to track time daily. It seems to have messed up the reports, and now I get an error message saying that there is duplicate data in one TimesheetLineID. What do i need to do to now track time that has been input on a daily basis, and how do i stop the error message.
There was an error when processing the data in the dataset.
Please try again later or contact support. If you contact support, please provide these details.
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.
Cluster URIWABI-UK-SOUTH-B-PRIMARY-redirect.analysis.windows.net
Activity IDaa3b2bab-7570-4791-9c3c-746406f217b0
Request ID997306be-f9cb-08eb-fbaa-ceafe52702cf
Time2020-07-08 13:25:14Z
RE: PowerBI and Project Online
Hi Sue,
Thank you for the forum question.
The error says that you have duplicate values in a primary key column. My guess is that you have a week id, which was unique but after changing the source to daily entries you have the week id for each day of the week. Relationships must include a primary key (a unique column).
Do you have a unique date columns in the table? If you have a date column and you have many entries for each day you may be can use your date table for the relationships. You will have a primary key in the date table.
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
