Forum Discussion
Solved
Best practice for structuring data with Header and Lines tables
I am looking for some feedback on structuring data in Power Bi which is organized via header and lines tables. Specifically, this data is coming from Business Central - almost all of the tables are s...
Hi Iachlan
I have worked a lot with Microsoft Dynamics data like this.
The awnser is, Best practice, create a star schema. I could explain why but Albero did it way better.
https://www.sqlbi.com/articles/header-detail-vs-star-schema-models-in-tabular-and-power-bi/I believe this should solve most of your issues.
Best regards,
Jeroen Dekker
I think you just have the direction of the relationships the wrong way around.
The order description is a dimension of the item or resource fact tables, not the other way around.
Changing the direction will take care of your problems with having multiple relationships from Order Lines Table, as they can both be active.