Forum Discussion
Best practices for working with star model?
Community ChampionAnonymous also ensure cross filter direction is set to Single for all the relations and then you will be able to also add relations for the tables that is missing currently. If you have cross filter direction to Both unfortunately you won't be able to set relations for all the tables.
Community ChampionIf you're moving from a working Qlickview to PowerBI I see no reason at all to modify table structures. It's a reporting-system (read only), serving the same purpose just like Power BI and if it has been designed according to good practices and performs alright - no reason to adjust the model.
From my personal experience I can say that if peoply don't really understand data modelling (including basic understanding of the business processes involved), there is a very high chance that they only make things worse they start to modify it.
My recommendation: Build a proper foundation of data modelling understanding before you get going on this terrain. I wouldn't argue against jumping head-first into many IT areas, but this is one of the few where I strongly recommend against!