There was an error when processing the data in the dataset.

[Anonymous]

Not sure how to correct this error. Very little experience with power BI. dly help.

Data source error:

Column '<pii>reservationOrderId</pii>' in Table '<pii>RI charges</pii>' contains a duplicate value '<pii>4c8ad6f8-5518-4787-a74e-0b56b1bfb99f</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.

[v-luwang-msft]

Hi @Anonymous ，

Has your problem been solved, if so, please consider Accept a correct reply as the solution or share your own solution to help others find it.

Best Regards
Lucien

[v-luwang-msft]

Hi @Anonymous ,

Please check the relationships between the tables to see if some relationships have been created automatically causing this error. For a case with the same problem refer:

https://community.powerbi.com/t5/Desktop/Get-quot-not-allowed-for-columns-on-the-one-side-of-a-many-to/m-p/68775 

Best Regards

Lucien