PowerBI and Project Online

Resolved · Urgent Priority · Version 2016

Wed 8 Jul 2020, 14:27 Delegate 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:27 Trainer 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.

Training courses

	98.8 % recommend us
	More live stats...

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions
Popular forum topics

Power BI tip:

Explore Power BI Templates

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

View all Power BI hints and tips