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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare 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
Oct Fabric Update Carousel

Fabric Monthly Update - October 2024

Check out the October 2024 Fabric update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

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