Error Encountered During Data Factory Pipeline Execution

[Chelly]

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

[v-nikhilan-msft · Accepted solution]

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.

Click on Add lakehouse.

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

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

[Tini · Accepted solution]

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.

After doing this, the pipeline ran fine for me.

[LukeMC123]

Yep it worked to remove and add back

[v-nikhilan-msft · Accepted solution]

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.

Click on Add lakehouse.

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

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

[vasiletamas]

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.

[v-nikhilan-msft]

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