Forum Discussion

wefter99's avatar
wefter99
Frequent Visitor
3 years ago

Duplicate IDs when appending tables

i have 2 sharepoint lists which I am using to create a report in PowerBI. In PowerBI i have appended one list to the other so that all the data is in one place. Whilst the entires have unique IDs in their own table, the appended version means some IDs are duplicated. Unfortunately a different function in the report references the IDs, and is linking to both entires with the same ID. Is there any way I can keep them seperate?

Need Help

1 Reply

  • SanderVeeken's avatar
    SanderVeeken
    Icon for Helper III rankHelper III
    3 years ago

    If you mean that although the IDs are the same, the values/entries are different, then you really need to make them unique again. Assuming you used the "Sharepoint folder" connector, there should be a Source.Name column after using "combine files".

     

    EDIT: sorry, I just read you used lists. Similar principle applies though, for clarity merge source info column with ID column for new ID. If you can't do that, creating an index column always works.

     

    Just merge that with whichever ID column you used before.