Forum Discussion

Ankit_Tiwari's avatar
Ankit_Tiwari
New Member
2 years ago

Bidirectional Cross Filtering not working for Directquery in Semantic Model After July Update

Hi Community,   Bidirectional Cross Filtering is not working for Directquery for Semantic Model having multiple tables after July Update of Power Bi Desktop. Earlier, it used to work for all table...
General Comment
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Ankit_Tiwari ,

amitchandak Thanks for your reply!

And Ankit_Tiwari , I need more information to reproduce your question.
I have tried myself DirectQuery connecting to SQL Server, Live Connection connecting to Analysis Service and then switching to DirectQuery, DirectQuery connecting to both SQL Server and Analysis Service, but none of them can reproduce your problem. And I don't see any other users reporting the same issue.

May I ask what your data source is? As well as I need you to provide your existing relationship view.

Best Regards,
Dino Tao

Ankit_Tiwari's avatar
Ankit_Tiwari
New Member
2 years ago

Hi Dino,

Thanks for looking into this.

Issue:

1. We already have a master table (import table) in the Model.

2. We have added four tables from PBI semantic model (Directquery mode).

3. When we try to establish relation(many to many) b/w the master table (in point 1) to one of the table (in point 2), it works for one table but fails for other three tables.