Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
Cobra77
Post Patron
Post Patron

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.)

Cobra77_0-1705327069717.png

Cobra77_3-1705327468441.png

 

Cobra77_2-1705327278513.png

 


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

1 ACCEPTED SOLUTION
aj1973
Community Champion
Community 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.

 

 

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

View solution in original post

1 REPLY 1
aj1973
Community Champion
Community 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.

 

 

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.