Forum Discussion
Opportunity Estimate Sales Order Data Modelling Question
Power BI likes its data organized in facts and dimensions. It's not a hard requirement, but often leads to better performance. In your case you will have to accept that the pristine 1:* relationships are not possible, and you have to carefully curate the direction of the *:* relationships to emulate a dimension -> fact hierarchy.
Bridge tables are dimension tables that weren't invited to the party. They are usually a design red flag. Instead, use TREATAS
Hi KunalKawale ,
Thanks for reaching out to the Microsoft fabric community forum.
I would also take a moment to thank lbendlin , for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.
I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We’re always here to support you.
Community Support Team
Hi KunalKawale ,
I hope the information provided above assists you in resolving the issue. If you have any additional questions or concerns, please do not hesitate to contact us. We are here to support you and will be happy to help with any further assistance you may need.
Thank you. Hi KunalKawale ,
I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We’re always here to support you.
Thank you.