Solved: There was an error when processing the data in the...

Anonymous · ‎06-27-2022

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 · ‎06-27-2022

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.

------------------------------------------------
1. How to get your question answered quickly - good questions get good answers!
2. Learning how to fish > being spoon-fed without active thinking.
3. Please accept as a solution posts that resolve your questions.
------------------------------------------------
BI Blog: Datamarts | RLS/OLS | Dev Tools | Languages | Aggregations | XMLA/APIs | Field Parameters | Custom Visuals

View solution in original post

otravers · ‎06-27-2022

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.

------------------------------------------------
1. How to get your question answered quickly - good questions get good answers!
2. Learning how to fish > being spoon-fed without active thinking.
3. Please accept as a solution posts that resolve your questions.
------------------------------------------------
BI Blog: Datamarts | RLS/OLS | Dev Tools | Languages | Aggregations | XMLA/APIs | Field Parameters | Custom Visuals