Create a snowflake model where Provincia is a central dimension attached to a link table with suitable keys. The idea is that if you can't keep dimensions on the outer layer, put them in the center.
Moreover, Povincia, Municipio and Comunidad on average can be organised into a hierarchy where only one of those is connected to the facts. That way you can create a real SnowFlake model.
Try to give Alias name for those fields which you don't want to link with other tables(if there is any same field name as different table field name) then it won't show circular reference.
And Read this document also for better understanding how to create good schema.
Thank you for your answers.
Anyway, first of all, I apply a Mapping Load, because the "Provincia" value in the t_Provincia and the t_Super were different.
Then, I have to make a LEFT JOIN in the "t_Distribuidor" to populate that table with the correct IdProvincia, in order to have the real id, and not the value Provincia, so I can have the same field in t_Super and t_Distribuidor.
I've have now something like this.
I guess now it is correct, isnt't it?
I post how I create my LinkTable.
Distribuidor_idProvincia AS idProvincia,
Distribuidor_Distribuidor AS Distribuidor
Super_idProvincia as idProvincia,
Super_Distribuidor AS Distribuidor
DROP Fields Distribuidor_idProvincia, Super_idProvincia, Super_Distribuidor, Distribuidor_Distribuidor