Forum Discussion
Error message: Excel allows only one filtering path between tables in a data model
I posted the same issue on other social.msdn.microsoft.com forum and one member suggested a solution to this problem. This solution has worked for me and for him. It looks like Visual Studio has a major bug related to the Bi-directional relationships.
Below is the solution:
Hi,
It worked for 2 Dimensions only. Let me explain my Model. I have 2 Fact tables One Budget and other Actual. I have 9 Dimension Tables. Out 9 Dimensions, one dimension only connected to Actual and Rest all 8 dimensions connected to both the fact tables.
Now When I try to change Filter Direction:=To Both Tables between Fact Actual and Dimension Date, I am keep getting this message: :The relationship you are creating lets you filter Budget by dates, but excel allows only one filtering path between tables in data model. Deactivate existing relationship between the tables or change their direction. This relationship can be added as inactive.
Gurus, pls can you explain?