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?
Solved! Go to Solution.
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_g9hTXWE
https://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
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_g9hTXWE
https://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