Solving “You cannot activate the relationship because a set of active relationships already exists between tables…” in PowerPivot and tabular cubes

When you create relationships between tables in PowerPivot (or in a SSAS tabular cube), you may run into the following message: Below I’ll explain a way to solve this. By setting relationships in the designer you tell PowerPivot how the tables are related. This is important because that’s how PowerPivot knows how to slice and…