Data Modelling

Hi mohallaham ,

Thanks for reaching out to Microsoft Fabric Community.

Just wanted to check if the responses shared address your question. They correctly explain the modeling limitation and the valid approaches when a shared business key exists.

If you are still facing issues applying this to your scenario, please share a small sample of the fact and dimension tables along with the expected outcome. That will help confirm whether a clean relationship can be established or if the limitation is with the source data itself.

How to provide sample data in the Power BI Forum - Microsoft Fabric Community

Thank you.