Relations in Power Pivot is not the same as in the underlying Access database
Posted on 2014-10-20
I have an Excel report, that is based on a powerpivot, that has the data from an underlying Access database.
In that database, I have a one to many relation from my products tabel to my sales database. But when I go into my PowerPivot, this relation is turned around, so I have a one to many relation from my sales database to my products tabel.
How can that happen and how can I secure, that the relation from products to sales data is kept?