The data model is incorrectly identifying the relationships between tables in data warehouse

[Jotheesh]

I have created TableA with a primary key and created TableB with a Foreign Key that references the Primary key of TableA so ideally oi would expect the Data Model to detect the relationship to be "One to many" from TableA to TableB but the Data model is detecting the relationship as "Many to one" from TableA to TableB.

[v-cboorla-msft]

Hi @Jotheesh 

Thanks for using Microsoft Fabric Community.

Apologies for the issue that you are facing.

This might require a deeper investigation from our engineering team about your workspace, the pipeline details and the logic behind it to properly understand what might be happening. 

Please go ahead and raise a support ticket to reach our support team:

https://support.fabric.microsoft.com/support
Please provide the ticket number here as we can keep an eye on it.

Thank you.

[v-cboorla-msft]

Hi @Jotheesh 

We haven’t heard from you on the last response and was just checking back to see if you got a chance to create a support ticket? If yes, please provide the ticket number here as we can keep an eye on it.

Thanks

[v-cboorla-msft]

Hi @Jotheesh 

We haven’t heard from you on the last response and was just checking back to see if you got a chance to create a support ticket? If yes, please provide the ticket number here as we can keep an eye on it.
In case if you have any other question on a different issue, we request you to open a new thread.

Thanks

[AndyDDC]

Hi @Jotheesh this has been occurring for several other people too (including me) You will need to raise a support ticket with Microsoft and they can look at the issues.