topic Re: The data model is incorrectly identifying the relationships between tables in data warehouse in Data Warehouse

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

Jotheesh — Tue, 28 Nov 2023 01:13:02 GMT

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.

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

AndyDDC — Tue, 28 Nov 2023 07:32:35 GMT

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.

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

v-cboorla-msft — Mon, 04 Dec 2023 06:57:09 GMT

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.

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

v-cboorla-msft — Thu, 07 Dec 2023 07:08:10 GMT

Hi Jotheesh

Thanks

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

v-cboorla-msft — Fri, 08 Dec 2023 10:07:22 GMT

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