Solved: Power BI Report Server relationships and models fe...

MCstudio · ‎09-28-2022

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?

v-luwang-msft · ‎09-29-2022

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

View solution in original post

v-luwang-msft · ‎09-29-2022

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