Forum Discussion

yangty's avatar
yangty
Frequent Visitor
1 year ago
Solved

Run notebook with T-SQL code in the pipeline issue

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: ...
Data Pipeline
Notebook
  • Anonymous's avatar
    Anonymous
    1 year ago

    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.


Anonymous's avatar
Anonymous
Not applicable
1 year ago

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!