Power bi can't filter CIM ?

[Anonymous]

Hello everybody !

I would like to use power bi with mysql connector ( mysql moodle database ) but when i want to filter tables, it can work fine for 1-N relationships ( when I filter children, it filter father ) but not when relationships are CIM relationships

A table with an id used by 2 other tables seems to don't permit filering through

A -> B ( N-1 through A to B )

C -> B ( N-1 through C to B )

I can recup A fields, filer on B fields but not on C fields ( power bi say "power bi can't found relationship on 1 or more fields" )

How can i resolve that ?

[v-frfei-msft]

Hi @Anonymous ,

How about setting the direction from single to both for your relationships?

For more details, please check the online document.

https://docs.microsoft.com/en-us/power-bi/desktop-create-and-manage-relationships