Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Problem changing one data source for another identical one

Hello everyone!   I created a data model from one data source. That data source will be updated every week, by adding more data at the bottom. Some of the data we add every week will be repeated, a...
Need Help
Tips and Tricks
Tutorial Requests
AW11's avatar
AW11
Helper I
3 years ago

I believe you are not having an issue with pulling the data, but with the relationships within the model. It is saying your identifier field has duplicate values which cannot happen. In Power Query, try removing duplicates in column 'ID2' and then refreshing.

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi! Thank you for explaining the error message.

     

    I suppose the duplicate would be in the new data source, since I was not having this problem with the old one. I will have to go through it, since there really should be no duplicates. ID2 is a concatenation of opp ID and date of snapshot.

     

    I will take a look and circle back. Thank you!