Forum Discussion
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 ?
1 Reply
- v-frfei-msft
Community Support
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