Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Sharepoint folder connector - Access Database

 

 

Hello,

I have been working with sharepoint folder containing multiple MS ACCESS files from different projects.

Couple of my ACCESS database files have tables (elements) with similiar ID's which is the reason i am getting an error message of duplicate values  (see attached picture below).

Is there any workaround you can suggest as having a unique ID is basic principle of realtional databases.

Need Help

2 Replies

  • dax's avatar
    dax
    Community Support
    6 years ago

    Hi rchowdhary, 

    Did you want to remove duplicate or you want to solve above error? If so, you could try to modify this in PowerBI desktop, you could try to use many -many relationship between two tables. Or if you want to use many-one relationship, you need to make sure the ID in "one part" is unique, you could click Edit Queries, the right click ID column->remove duplicates.

    Best Regards,
    Zoe Zhi

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      ´So this how my single project Access file looks like which contains a table (named:Level) that has relation to all other tables in that file. So, if accidentally another project contains same ID (which is exactly my case) and i set the cardinality to (Many to Many) it will visualize data from other project as well which will be incorrect.

      So actually i would like change this ID (by giving a new ID) from all tables at once. Is ther any way to accomplish this in PowerBi query or perhaps editing Access Query.