PowerBI has a PowerQuery function that allows this OOTB. We’ve published a Youtube tutorial for this (linked at the end of this post)
Suppose a project has 3 Models: Structure, Fabric and Ductwork (I am reusing my model from the Automate Clash Analysis demo)
Each of those models has a unique URL.
Add a Data source for each:
For later use, I add a custom column for identity purposes.
Then you can add a new Query using the Append Queries (as new) tool:
Or simply write the PowerQuery yourself; I’ve named this “Federated”.
This “Federated” source can be added to the Visual and any other dashboard elements you want.
All the regular colouring and filtering will be possible with a single data source.
We’ve published a Youtube tutorial for this:
It is possible to federate Models across Projects, but unless they are co-located and relatively small, I wouldn’t recommend it.