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 whi...
Need Help
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.