Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Can't make Relationship active

I'm trying to mimic a MS Acess query in my PBI report. The MS Query is matching these two fields together and without this join in my PBI report I'm getting extrat rows that shouldn't be inclouded. H...
Need Help
  • NaveenGandhi's avatar
    NaveenGandhi
    2 years ago

    Hi Anonymous 

    The relationship you have between other tables, TIDDVDDTL,TIDDSLOC and TIDDVDDTL seems to be circular which is not allowed in PBI, You have to remove any on of these to resolve this.



    If this post helps, then please consider Accept it as the solution to help the others find it more quickly. Appreciate you kudos!!

    Follow me on LinkedIn!!!

NaveenGandhi's avatar
NaveenGandhi
Icon for Memorable Member rankMemorable Member
2 years ago

Hi Anonymous 

The relationship you have between other tables, TIDDVDDTL,TIDDSLOC and TIDDVDDTL seems to be circular which is not allowed in PBI, You have to remove any on of these to resolve this.



If this post helps, then please consider Accept it as the solution to help the others find it more quickly. Appreciate you kudos!!

Follow me on LinkedIn!!!

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi,Anonymous 

    Can you tell me if your problem is solved? If yes, please accept it as solution.

     

    Best Regards,

    Leroy Lu