Troubleshooting PowerPivot Relationships

So you are working with multiple tables with PowerPivot, press the create relationship button and then you get the dreaded "No Relationship detected" error message.

Read more...