Run notebook with T-SQL code in the pipeline issue

[yangty]

I have simple T-SQL query in a notebook which is just insert records to a datawarehouse table, and I can run it from the notebook. When I tried to run it from the pipeline I received error as below:

Any idea what will cause this error?

Thanks!

[v-pagayam-msft]

Hi @yangty ,
I wanted to check in on your situation regarding the issue. Have you resolved it? If you have, please consider marking the reply that helped you or sharing your solution. It would be greatly appreciated by others in the community who may have the same question.

Thank you for being a part of the Microsoft Fabric Community Forum!

[v-pagayam-msft]

Hi @yangty ,
We haven't heard back from you regarding our last response and wanted to check if your issue has been resolved.
If our response addressed your query, please mark it as Accept Answer and click Yes if you found it helpful.
If you have any further questions, feel free to reach out.

Thank you for being a part of the Microsoft Fabric Community Forum!

[v-pagayam-msft]

Hi @yangty ,
May I ask if you have gotten this issue resolved?
If it is solved, please mark the helpful reply or share your solution and accept it as solution, it will be helpful for other members of the community who have similar problems as yours to solve it faster.

Thank you for being a valued member of the Microsoft Fabric Community Forum!

[v-pagayam-msft · Accepted solution]

Hi @yangty ,
Thank you for reaching out to the Microsoft Fabric Community Forum about the issue you are encountering.

In the workspace, navigate to Data Pipelines and open the pipeline that runs the notebook. Click on the Notebook activity and check the linked service under Settings. If the authentication token has expired, re-authenticate by clicking Edit Linked Service, signing in again with valid credentials, and then clicking Save may help you to figure out the issue.

Refer the link here for clear understanding about T-sql in notebook.

If this post helps, please give us Kudos and consider Accept it as a solution to help the other members find it more quickly.

[slachmuyldera]

I am having the exact same error as described above. The notebook activity does not have any "linked service" under settings.  Only to select the workspace and the notebook. Can you please clarify?