Enabling Power BI to use multiple relations in a dataset to be able to improve filtering and enable complex relationship models.
It does not have to be multiple relationships between 2 tables, but at least enabling several relationship paths.
Currently when You have a simple relation like:
Dates --> Maintenance Requests Dates --> Spare Part Consumption Plants --> Maintenance Requests Plants --> Spare Part Consumption Spare Part Consumption --> Maintenance Requests (i.e. spare part usage might be connected with maintenance requests)
there is no way to make any sensible matching / filtering. Although there are some workarounds for that, it odes not allow You anything close to full functionality.
I find it the biggest gap in Power Bi data model and the biggest opportunity for improvement.
nschachter
on:
Tags/Labels to structure all fabric content
on:
Fabric free trial