Forum Discussion
Some methods in notebooks do not work when executed from Data Pipelines deployed via SPN
Just to update everyone based on the most recent discussion with Microsoft support on the support case: They have pointed me to Fabric Community forums (so here where we already started discussion and report this issue) and to the Ideas part, so I also created an idea referencing this thread and pointing that this is a known issue and also asking for a fix and/or a workaround.
Please vote here: https://community.fabric.microsoft.com/t5/Fabric-Ideas/Enable-notebookutils-and-other-methods-to-work-when-executed/idi-p/4674315#M160577
Hi mmilosanovic ,
Thank you for the update and for continuing to raise visibility across the support channels and community.
As acknowledged internally, this behavior is a known limitation when executing notebooks via Service Principal authentication, where certain methods like notebookutils may not function as expected due to context initialization issues. The product team is actively reviewing the scenario, and we anticipate future improvements to address these limitations.
Your engagement through the Ideas forum is appreciated and will help with prioritization. We’ll continue to monitor this and share any updates or guidance as they become available.
Also please try to review the information provided by gaya3krishnan86 which might help you.
If this post helps, then please give us Kudos and consider Accept it as a solution to help the other members find it more quickly.
Thankyou.
- mmilosanovic1 year agoAdvocate IV
Hi everyone,
I just got feedback from the support that Notebook PG team has fixed the issue. I tested again and it seems to work now. I only tested
notebookutils.runtime.context.get("currentWorkspaceName")so not sure if this also fixes all the
notebookutilsmethods or
synapsesql()methods.
Can someone else also give it a try and share findings here?
Best regards,
Milos
- Anonymous1 year agoNot applicable
Hi mmilosanovic ,
Thank you for following up and sharing that the issue was resolved through Microsoft Support. We're glad to hear that your concern has been addressed successfully.
Please make your answer as accepted. Your input is valuable, and sharing the outcome helps others in the community facing similar issues.
If you have any further questions or need assistance in the future, please don’t hesitate to create a new post on the Microsoft Fabric Community Forum we’re always here to help.
Thank you.
- mmilosanovic1 year agoAdvocate IV
hi Anonymous this is still not resolved and ongoing with MS support, specifically around other methods (issue seem to be the same with authorization) like synapsesql().
- annhwallinger1 year agoHelper I
synapsesql() still doesn't work and per Microsoft yesterday is not supported with SPN at this time and there is no date for when it will be so I guess it is not a real tool yet.