Can't make Relationship active

[U156531]

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. How do I get around this issue? Thanks

[NaveenGandhi · Accepted solution]

Hi @U156531 

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!!!

[v-linyulu-msft]

Hi,@U156531 

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

Best Regards,

Leroy Lu