topic Re: Update table with relationship in warehouse : Couldn't refresh the entity because of an issue in Data Warehouse

Update table with relationship in warehouse : Couldn't refresh the entity because of an issue

AlexisReconomia — Wed, 20 Dec 2023 08:53:27 GMT

I have some tables in my warehouse that are updated with a dataflow. I created relationships between these tables in the model view, and now I want to update these tables by refreshing my dataflow. Theoretically, it should work, but I am encountering an error (see the first image below).

How can I solve this? Or how can I update my table with the relationship?

I paste the error code here : 104100 Couldn't refresh the entity because of an issue with the mashup document MashupException.Error: DataSource.Error: Microsoft SQL: Could not drop object 'Ware_BiData.dbo.Dataflow_Calendar' because it is referenced by a FOREIGN KEY constraint. Statement ID: {E1A588A5-A49C-4475-B840-EA8574853D9C} Details: Reason = DataSource.Error;DataSourceKind = Warehouse;DataSourcePath = Warehouse;Message = Could not drop object 'Ware_BiData.dbo.Dataflow_Calendar' because it is referenced by a FOREIGN KEY constraint. Statement ID: {E1A588A5-A49C-4475-B840-EA8574853D9C};ErrorCode = -2146232060;Number = 3726;Class = 16;State = 1;Microsoft.Data.Mashup.Error.Context = User

Re: Update table with relationship in warehouse : Couldn't refresh the entity because of an issue

AndyDDC — Wed, 20 Dec 2023 22:48:30 GMT

Hi AlexisReconomia is the dataflow set to Append or Overwrite?

Re: Update table with relationship in warehouse : Couldn't refresh the entity because of an issue

AlexisReconomia — Thu, 21 Dec 2023 09:34:54 GMT

overwrite

Re: Update table with relationship in warehouse : Couldn't refresh the entity because of an issue

v-cboorla-msft — Thu, 11 Jan 2024 06:13:53 GMT

Hi AlexisReconomia

Thanks for using Microsoft Fabric Community.

Apologies for the delay in response and the issue that you are facing here.

Following you up to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others.
Otherwise, will respond back with the more details and we will try to help.

Thanks

Re: Update table with relationship in warehouse : Couldn't refresh the entity because of an issue

v-cboorla-msft — Tue, 16 Jan 2024 13:31:27 GMT

Hi AlexisReconomia

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet.
In case if you have any resolution please do share that same with the community as it can be helpful to others.
If you have any question relating to the current thread, please do let us know and we will try out best to help you.
In case if you have any other question on a different issue, we request you to open a new thread.

Thanks.

Re: Update table with relationship in warehouse : Couldn't refresh the entity because of an issue

Data-Crunch — Wed, 24 Jan 2024 18:03:44 GMT

Same issue here, also set the dataflow Gen2 to overwrite in data destination! Any help?