Behind the scenes of PowerPivot’s automatic relationship detection

At times you will see a notification for the automatic relationship detection appear at the top of the PowerPivot Field List, yet no relationships can be detected. Why?

This can be caused by multiple reasons, which are described below.

Read more...