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 ,
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!