Multiple relations support for Power BI datasets

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.