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
New_worker
Helper II
Helper II

Add data to lakehouse from Azure storage

Hi-

I am preparing an exam, but I am always confused with the question. Here it says "add", does it mean to physically import or ingest data? Or just access and reference? 

 

You have a Fabric tenant named Tenant1 that contains a lakehouse named Lakehouse1.
You need to add data to Lakehouse1 from a CSV file in an Azure Storage account outside of Fabric. The solution must minimize development effort.
What should you use to add the data?
A. copy job
B. shortcut
C. pipeline
D. Dataflow Gen2

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hi @New_worker 
Thank you for reaching out microsoft fabric community forum.
yes ,you are right . Copy job  is correct.copy job physically ingests the data into Lakehouse1 from an external source like Azure Storage. It's the simplest way to add data with minimal development effort.
If this solution helps, please consider giving us Kudos and accepting it as the solution so that it may assist other members in the community
Thank you.






View solution in original post

6 REPLIES 6
Anonymous
Not applicable

Hi @New_worker 
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.

rohit1991
Super User
Super User

Hi @New_worker ,

 

In this case, the term "add data to Lakehouse1" from a CSV file stored in Azure Storage (outside Fabric) clearly implies that the data needs to be physically ingested not just referenced. Since the source is external, a shortcut won’t work here. Shortcuts only reference data already within OneLake, and that’s not the case in this scenario.

 So the correct answer is A. Copy job.

A copy job moves the data into OneLake behind the scenes and makes it part of the Lakehouse. It’s simple, low-effort, and doesn’t require setting up full pipelines exactly what the question is aiming for when it says “minimal development effort.”


Did it work? ✔ Give a Kudo • Mark as Solution – help others too!
Anonymous
Not applicable

Hi @New_worker 

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

 

Anonymous
Not applicable

Hi @New_worker 
Thank you for reaching out microsoft fabric community forum.
yes ,you are right . Copy job  is correct.copy job physically ingests the data into Lakehouse1 from an external source like Azure Storage. It's the simplest way to add data with minimal development effort.
If this solution helps, please consider giving us Kudos and accepting it as the solution so that it may assist other members in the community
Thank you.






Deku
Super User
Super User

It means ingest in this case. Shortcutting only works within onelake, but in that question the data source is outside of fabric.


Did I answer your question?
Please help by clicking the thumbs up button and mark my post as a solution!

Thanks @Deku for your reply.

I dont think shortcut only works within onelake. But if it means ingest data, then the answer should be A. copy job. 

Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI 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.

Top Solution Authors
Top Kudoed Authors