Forum Discussion
Solved
Cannot create active relationship between date table and multiple dim tables
I am new to data modeling and require help. I have multiple fact tables (Tables - Data_2020, Data_2021, Data_2022, Data_Fifa) year-wise and I want to connect them to one date table, however, the dat...
You are doubling relationships if you make connection to dimtables and between data tables.
Model works if you delete many to many and connect 🙂
Thanks for the PBIX. However, ideally we should be creating the structure in Power Query, and for that I will also need sample files for the different tables (otherwise I cannot work the model in Power Query). Perhaps you can create a zip file with the pbix and the sample files to download?
Thanks, but the link doesn't lead to a download