Dataflow gen 2 stuck in refresh

[manoplaeli]

I have few collmns in dataflow gen2 that I want to ingest to data warehouse. After published, it takes forever fore refresh and it never be able to put data in the warehouse. I was succesfully import data once when I was using get data inside the data warehouse. It doesn't work when I create the dataflow gen2 in different workspace and ingest to data warehouse in a different workspace. I am admin for both workspace. Is this a bug or I did something wrong?

[v-cboorla-msft · Accepted solution]

Hi @manoplaeli,

Welcome to Microsoft Fabric platform and thanks for posting your question here.

I understand that you're facing a conflict error while doing deployment.

Follow the below steps in order to troubleshoot:

1. Can you please retry the Dataflow Gen2 in order to load the data from one workspace to another workspace. (Note: Kindly make sure that data warehouse is created in the destination workspace)
2. If the above steps fail to resolve your issue, please let us know the process that you are following in order to create the Dataflow Gen2 and share the complete refresh history details.

   Regarding your question about creating the dataflow gen2 in a different workspace and ingesting it into a different workspace, it is possible to do so. However, you need to make sure that the necessary permissions are granted for both workspaces.

   

   I hope this information helps you resolve the issue. Let me know if you have any further questions or concerns.

[manoplaeli · Accepted solution]

@v-cboorla-msft Thank you for your time. I am able to solve the problem now. Below was the error that I recieve. There was miss match in data type. I was uploading the data from excel file. There were few rows that can't be converted so I just make sure that all the data is in the correct type, then the upload was success full. 

Thank you for your time

[v-cboorla-msft]

@manoplaeli Glad to know that your issue got resolved. Continue to use Fabric Community platform for any question related to Microsoft Fabric!

[v-cboorla-msft · Accepted solution]

Hi @manoplaeli,

Welcome to Microsoft Fabric platform and thanks for posting your question here.

I understand that you're facing a conflict error while doing deployment.

Follow the below steps in order to troubleshoot:

1. Can you please retry the Dataflow Gen2 in order to load the data from one workspace to another workspace. (Note: Kindly make sure that data warehouse is created in the destination workspace)
2. If the above steps fail to resolve your issue, please let us know the process that you are following in order to create the Dataflow Gen2 and share the complete refresh history details.

   Regarding your question about creating the dataflow gen2 in a different workspace and ingesting it into a different workspace, it is possible to do so. However, you need to make sure that the necessary permissions are granted for both workspaces.

   

   I hope this information helps you resolve the issue. Let me know if you have any further questions or concerns.

[v-cboorla-msft]

Hi @manoplaeli 

Following up to see if the above answer was helpful. And, if you have any further query do let us know.