Forum Discussion
Power BI Report Server relationships and models features
Hi community!
Power BI Report Server the new version (September 2022) has been released, but it still doesn't contain Many-to-many relationships and Composite models.
Have you got any news, are they going to include these features, and if yes, when?
Hi MCstudio ，
Hi MCstudio ，
Unfortunately, there is no news on when the feature you propose will go live on Report Server. composite models was proposed by a user in 2018, but unfortunately it is still not feasible. For many-to-many relationships, you may want to consider bridge tables,which does the magic of connecting tables creating the same result as a many to many. You can find more about this technique searching on google. Here are some sources that might be helpful:
https://www.youtube.com/watch?v=Sge_g9hTXWEhttps://www.youtube.com/watch?v=l6hR2Me6Ang
https://www.seerinteractive.com/blog/join-many-many-power-bi/If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Lucien
1 Reply
Hi MCstudio ，
Hi MCstudio ，
Unfortunately, there is no news on when the feature you propose will go live on Report Server. composite models was proposed by a user in 2018, but unfortunately it is still not feasible. For many-to-many relationships, you may want to consider bridge tables,which does the magic of connecting tables creating the same result as a many to many. You can find more about this technique searching on google. Here are some sources that might be helpful:
https://www.youtube.com/watch?v=Sge_g9hTXWEhttps://www.youtube.com/watch?v=l6hR2Me6Ang
https://www.seerinteractive.com/blog/join-many-many-power-bi/If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Lucien