Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
Anonymous
Not applicable

There was an error when processing the data in the dataset

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

1 ACCEPTED SOLUTION
otravers
Community Champion
Community Champion

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

1 REPLY 1
otravers
Community Champion
Community Champion

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

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors