Relationships work in Power Pivot but not Power BI

[acrmorris]

Hi All,

I am very new (just 3 days use!) to Power BI, so I am sure I am missing something obvious and apologies if I am.

I have created a simple test environment in Power Pivot using live company data from the ERP database and then a budget table.

I have also created 2 further tables, one with detail of sales reps, one with Year/Month detail.

In Power Pivot, the 4 relationships between these 4 tables work without issue and I am able to extract a pivot by Rep/Year/Month comparing budget to actual, but replicating the measures and relationships in Power BI throws out a relationship activation error. I am completely at a loss as to why everything works with one but not the other.

Any thoughts?

[acrmorris · Accepted solution]

Problem solved. Amending Cross Filter Direction from 'Both' to 'Single' did the trick! Not sure why, but I am sure the more I dig into this application the clearer it will become!