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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
TorgeHH
Frequent Visitor

Most efficient way to PUSH data into data warehouse

Hi, 

I am new to fabric. I have a scenario where I want to push data into my warehouse and not pull it. I know that there is a way to use functions for this, but is this the most efficient way? Any experience here?

 

Kind regards

3 REPLIES 3
TorgeHH
Frequent Visitor

Hey 🙂

there is a data source outside fabric, that wants to push data inside fabric.

I think it depends on what exactly you want to push.

 

Data that's processed and then is at rest in something like SQL database tables? I'd look at Mirroring.

 

Data at rest, but it's in files? See if you can use Shortcuts.

 

If it's being transformed or created by a process like logic apps or Databricks, you'd have to weigh the development time in writing the processes to push the data into a Fabric destination against writing it to a destination you have available and using one of the options I proposed above.

 

Hopefully this helps. If it does, be sure to accept the solution so others in the community can find it. If not, please provide more context into your source data structures (tables, files, etc.) and your desired storage format in Fabric.

DataBard
Resolver II
Resolver II

Hi @TorgeHH ,

Can you clarify your definition of push and pull? Does the push need to occur from outside of the warehouse, but still within Fabric? Or does the push need to occur outside of Fabric?

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! Prices go up Feb. 11th.

JanFabricDE_carousel

Fabric Monthly Update - January 2025

Explore the power of Python Notebooks in Fabric!

JanFabricDW_carousel

Fabric Monthly Update - January 2025

Unlock the latest Fabric Data Warehouse upgrades!

JanFabricDF_carousel

Fabric Monthly Update - January 2025

Take your data replication to the next level with Fabric's latest updates!