Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Power bi can't filter CIM ?

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 ?