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

To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.

Reply
smpa01
Super User
Super User

Copying data from on-premises connection with staging storage in workspace is not supporte

I am trying to incrementally load data from on-prem SQL to a data warehouse following this 

 

I am getting a validation error as following. Do you know why?

Copying data from on-premises connection with staging storage in workspace is not supported. Please use external staging storage instead.

 

smpa01_0-1721074951582.png

 

Did I answer your question? Mark my post as a solution!
Proud to be a Super User!
My custom visualization projects
Plotting Live Sound: Viz1
Beautiful News:Viz1, Viz2, Viz3
Visual Capitalist: Working Hrs
2 REPLIES 2
Anonymous
Not applicable

Hi @smpa01 ,

 

The error message indicates that copying data from a local connection using the workspace internal staging storage is not currently supported, and it is recommended to use an external staging storage.

 

To resolve this issue, you need to configure the data pipeline to use an external staging area instead of the internal workspace storage.

 

For example, use Azure Blob Storage or Azure Data Lake Storage Gen2 for this process.

 

For more information about copy data, see the official document below, which uses Azure Blob Storage:

How to copy data using copy activity - Microsoft Fabric | Microsoft Learn

 

If you have any other questions please feel free to contact me.

 

Best Regards,
Yang
Community Support Team

 

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

@Anonymous  I am not sure why staging from on-prem sql requires me to BYOBlob/BYOADLS2 (external and additional)?

 

@dbrowne  I guess this issue is similar to this and is there an ETA for Supporting OneLake as staging for on-premise to DW is on the roadmap

 

 

Did I answer your question? Mark my post as a solution!
Proud to be a Super User!
My custom visualization projects
Plotting Live Sound: Viz1
Beautiful News:Viz1, Viz2, Viz3
Visual Capitalist: Working Hrs

Helpful resources

Announcements
September Fabric Update Carousel

Fabric Monthly Update - September 2025

Check out the September 2025 Fabric update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

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