Forum Discussion
Does someone know if bi-directional cross-filtering will appear in Power Pivot?
Like in SSAS 2016 and Power BI desktop. Thanks
I haven't checked, but it may be in the latest update for Excel. IT's the same engine as the other two products, just a couple of months behind.
- Nope, it's not here. Yes, the same engine, just open the interface, but nothing. Perhaps some compatibility issues.
Right now found in discussion under this Many to Many Relationships in Power BI and Excel 2016 blog Marco Russo's answer on the question why bi-directional is omit in 2016:
"Because it would have changed the binary format of Power Pivot model, making the file incompatible with Excel 2013. They wanted to avoid the issue existing between Excel 2010 and Excel 2013 when you have a data model. You have to upgrade to open it in 2013, and after that you cannot open it in 2010. So for Excel 2016 they wanted to keep full compatibility of binary file format."
Nice spot - thanks. I'd like to see where this lands - it's a pretty fundamental incompatibility. The portable nature of Power Pivot is what makes it particularly compelling.
