In this video, I will focus on a scenario you have all faced. Is it good to have too many dimension tables? Can you combine some of those tables together to build one flat dimension table? How much should you flatten it? Should you end up with one huge table, including everything? In this video, I answer all these questions and explain the scenarios of combining dimensions. As usual, I explain the model in Power BI.
read my blog article on this subject here:
https://radacad.com/combining-dimension-tables-in-power-bi-using-power-query-basics-and-foundations-of-modeling