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

Join us at the 2025 Microsoft Fabric Community Conference. March 31 - April 2, Las Vegas, Nevada. Use code FABINSIDER for $400 discount. Register now

Reply
Chelly
Frequent Visitor

Error Encountered During Data Factory Pipeline Execution

Hello, I'm currently working on the 'Get Started with Fabric' exercise, specifically in the 'Modify the pipeline' section of using Data Factory pipelines in Microsoft Fabric. After running the pipeline, I encountered an error with the notebook activities. Despite retrying the exercise, I consistently face the same error message:

Operation on target 'Load Sales notebook' failed: Notebook execution encountered an error at the Notebook service with HTTP status code - '200'. Please review the Run logs on the Notebook for additional details. Error details: 'Error name - AnalysisException, Error value - org.apache.hadoop.hive.ql.metadata.HiveException: MetaException(message: Spark SQL queries are only possible in the context of a lakehouse. Please attach a lakehouse to proceed.)
Thanks

2 ACCEPTED SOLUTIONS
v-nikhilan-msft
Community Support
Community Support

Hi @Chelly 
Thanks for using Fabric Community.
Can you please follow the below steps and retry :

At the leftside of the notebook please click on lakehouses.

vnikhilanmsft_1-1709809452832.png


Click on Add lakehouse.

vnikhilanmsft_2-1709809483757.png

Select the lakehouse where the table resides. Attach the lakehouse to the notebook.

vnikhilanmsft_3-1709809529897.png


Now try to run the pipeline. Please let me know if the issue still persists.

 

View solution in original post

Tini
Frequent Visitor

Hello

I encountered the same issue, and the solution that worked for me was to navigate to the notebook, go to "Lakehouses," select "Remove all lakehouses," and then add the same lakehouse back.

Tini_1-1709815108325.png


After doing this, the pipeline ran fine for me.


View solution in original post

5 REPLIES 5
Tini
Frequent Visitor

Hello

I encountered the same issue, and the solution that worked for me was to navigate to the notebook, go to "Lakehouses," select "Remove all lakehouses," and then add the same lakehouse back.

Tini_1-1709815108325.png


After doing this, the pipeline ran fine for me.


Yep it worked to remove and add back
v-nikhilan-msft
Community Support
Community Support

Hi @Chelly 
Thanks for using Fabric Community.
Can you please follow the below steps and retry :

At the leftside of the notebook please click on lakehouses.

vnikhilanmsft_1-1709809452832.png


Click on Add lakehouse.

vnikhilanmsft_2-1709809483757.png

Select the lakehouse where the table resides. Attach the lakehouse to the notebook.

vnikhilanmsft_3-1709809529897.png


Now try to run the pipeline. Please let me know if the issue still persists.

 

I have the same problem but removing and adding the lakehouse doesn't solve it. It worked fine until recently, any suggestions on what I can try.

Hi @Chelly 
Glad that your query got resolved. Please continue using Fabric Community for any help regarding your queries.

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!

FebFBC_Carousel

Fabric Monthly Update - February 2025

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

Feb2025 NL Carousel

Fabric Community Update - February 2025

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

Top Kudoed Authors