How can we run a Fabric notebook on a schedule without depending on a interactive user account?

[RichardMartin]

Hi everyone. We have a situation that seems impossible to solve, but i don't think we are alone...

I have notebook in a Fabric workspace that runs on a schedule. It reads data from a shortcut-table in a lakehouse in the same workspace as the notebook. Then it writes data to a table in the same lakehouse.

If i remove my personal user account from the workspace access, the pipeline run fails. This means that the notebook is dependent on my personal account. This is unacceptable for a company data pipeline. Actually, if i remove the data loading part, and replace the whole notebook with one that simply does print("hi"), then it still fails to run.

How can we make the pipeline or the notebook use something other than my personal account, like for example a service principal?

[v-huijiey-msft]

Hi @RichardMartin ,

Is my follow-up just to ask if the problem has been solved?

If so, can you accept the correct answer as a solution or share your solution to help other members find it faster?

Thank you very much for your cooperation!

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

[v-huijiey-msft]

Hi @RichardMartin ,

Support for authenticating to OneLake using service principal and hosted identities. This allows users to access OneLake without having to use a user account.

There are 2 new settings that need to be enabled in the Admin Portal first.

Then workspace>>Manage access.

Next, click “+ Add Person or Group” and start typing in the name of the service owner or hosting identifier. It should populate in the suggestions list. Select it and click Add.

Finally, identify the roles you want to grant to the service body or hosted identity, such as Admin, Member, Contributor, Viewer.

For detailed reference information, please refer to the link below to learn more:

How to use service principal authentication to access Microsoft Fabric's OneLake - Sam Debruyn

If you have any other questions please feel free to contact me.

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!