98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Power BI training and help » PowerBI and Project Online
PowerBI and Project Online
Resolved · Urgent Priority · Version 2016
Wed 8 Jul 2020, 14:27Delegate Sue said...
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
Wed 8 Jul 2020, 19:27Trainer Jens said...
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
Wed 15 Jul 2020: Automatically marked as resolved.
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Power BI tip:Explore Power BI TemplatesTake advantage of Power BI templates to streamline report creation. Templates allow you to reuse custom layouts, themes, and configurations across multiple reports. Create templates for consistent branding or industry-specific reporting standards, saving time and maintaining a cohesive look across your organization's reports. |
