Database Modelling Remove Bridge Table

I have designed a database with some outside help and I am thinking about a major change to the database model because of a problem creating reports in Power BI I have recently enc

Solution 1:

Just to give this closure. It seems to be indeed a stupid idea, because I would duplicate rows connected to the end tables, as soon as I merge the information of the type with the Firms table.