cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
duncfair
Advocate I
Advocate I

Refresh error message demonstrably wrong - how to fix?

Data source error: Column '0-30%' in Table 'vw_TargetTool_Hist_2021' contains a duplicate value '<pii>68</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: vw_TargetTool_Hist_2021.
Cluster URI: WABI-US-NORTH-CENTRAL-E-PRIMARY-redirect.analysis.windows.net
Activity ID: c49ccf6d-4deb-4fa7-a581-7f3ab15e9f36
Request ID: 4b196b8c-e85c-607a-1b59-779c3b9f419a
Time: 2021-02-15 14:08:00Z

 

Only 7 rows in this view (7 fiscal weeks) so far this year. There are no duplicates. The value '68' only occurs a single time, so it's not even a duplicate value within the column.

1 ACCEPTED SOLUTION
timg
Solution Specialist
Solution Specialist

Hi duncfair,

Could you check if the relationship cardinality between this table and other tables is set correctly? If these are not set correctly it could also cause a duplicate error, so perhaps that's the culprit.

Regards,

Tim

View solution in original post

2 REPLIES 2
timg
Solution Specialist
Solution Specialist

Hi duncfair,

Could you check if the relationship cardinality between this table and other tables is set correctly? If these are not set correctly it could also cause a duplicate error, so perhaps that's the culprit.

Regards,

Tim

View solution in original post

Hi Tim,

 

Thanks! I was not the original creator of this report (I'm the backend data guy) and the issue was an auto-created relationship that didn't make any sense. Changing that resolved the error.

 

 

Helpful resources

Announcements
User Groups Public Preview

Join us for our User Group Public Preview!

Power BI User Groups are coming! Make sure you’re among the first to know when user groups go live for public preview.

March Update

Check it Out!

Click here to read more about the March 2021 Updates!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors