Forum Discussion
Fabric Gen 2 Error : WriteToDataDestination lakehouse or DW
Hi,
I'm trying to store SQL on Premise data in Fabrics via a Gateway (updated).
I can see my flow clearly, and the lakehouse as the destination, but it can't write in it ?
(Test with the DataWarehouse, same.)
104100 Couldn't refresh the entity because of an internal error
I am the workspace admin.
Where can this come from ?
Thanks for your help
Hi Cobra77
By default Dataflows data are stored directly in ADLS(Azure Data Lake Storage), so basicaly the message is saying that you can't store data that is already stored in the service. It would work if you did other way, by creating the Lakehouse from SQL server and then you can use Dataflow and storage destination.
1 Reply
- aj1973Community Champion
Hi Cobra77
By default Dataflows data are stored directly in ADLS(Azure Data Lake Storage), so basicaly the message is saying that you can't store data that is already stored in the service. It would work if you did other way, by creating the Lakehouse from SQL server and then you can use Dataflow and storage destination.