There was an error when processing the data in the dataset

[Anonymous]

I am getting this error message and unsure of what to do. May I get someones input?

Data source error: Column '<pii>POL GUID ResourceID</pii>' in Table '<pii>Rate Data</pii>' contains a duplicate value '<pii>92f66415-6b02-e811-80eb-00155d284520</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.
Cluster URI: WABI-SOUTH-CENTRAL-US-redirect.analysis.windows.net
Activity ID: 7e6b0f09-959a-4a13-b82d-2914d5a1a90a
Request ID: 6a924539-6d99-4cf6-a696-a96bd07c29b5
Time: 2022-06-24 20:55:02Z

[otravers · Accepted solution]

Is the Rate Data table a dimension table? You need to deduplicate the POL GUID ResourceID column, which you can do easily in Power Query.