Forum Discussion
cannot run t-sql notebook in pipeline
suggest to file a support ticket on this. thanks
Welcome to the Microsoft Fabric Forum,The error you are encountering, MwcTokenValidationException (HTTP 401), usually indicates a token validation issue related to authentication or authorization.
When a notebook is triggered through a pipeline in Microsoft Fabric, it uses a system-assigned managed identity or a service principal for authentication. If this identity or principal lacks the necessary permissions on the Datamart or Warehouse, the authentication will fail, even if the notebook runs successfully when executed manually.
Verify the permissions such as the service principal or user account running the pipeline has the appropriate read and write permissions to access the data warehouse.
Additionally, upgrading to the latest stable runtime version can sometimes resolve execution delays or metadata commit inconsistencies.
There is a known issue with the Distributed Query Processor (DQP) on the Microsoft side that could contribute to this behavior.
For further reference, a similar issue has been discussed in the following thread:
Solved: Unable to access Data Warehouse: MwcTokenValidatio... - Microsoft Fabric CommunityIf this information helps resolve your issue, kindly consider marking this response as the Accepted Solution, as it may assist other community members facing similar challenges.
Thank you for being part of the Microsoft Fabric Community.
Hi slachmuyldera
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.
I am in the process of trying to get some response back from support. So, no solution yet.
Hi slachmuyldera
Thank you for the update. If you have found a solution, please share it here, as it will help other community members facing similar issues. Looking forward to your response.
Regards,
Karpurapu D.We are following up once again regarding your query. Could you please confirm if the issue has been resolved through the support ticket with Microsoft?
If the issue has been resolved, we kindly request you to share the resolution or key insights here to help others in the community. If we don’t hear back, we’ll go ahead and close this thread.
Should you need further assistance in the future, we encourage you to reach out via the Microsoft Fabric Community Forum and create a new thread. We’ll be happy to help.
Thank you for your understanding and participation.
