Forum Discussion

bdelaney's avatar
bdelaney
Frequent Visitor
10 years ago

cross filter direction grayed out

Using Feb (latest) version of PBI desktop. Just added 3 tables from SQL Server. It is a very simple many:many relationship. The join table contains ONLY the two foreign keys. I tried to add a measure...
Need Help
pqian's avatar
pqian
Microsoft Employee
10 years ago

bdelaney Yep. BiDi relationship is one of the limitations of DirectQuery.

 

Measure should be working now.