Use Service principal with Sempy library and Get all the workspaces assigned to it

[bharathrs_nest]

Hi, 

We cannot get access to all workspaces in production, but we need to collate all workspaces and datasets in it. We have tried sempy in fabric notebook, but it uses the token of the person who has logged in / created the pipeline. Is there a way to use Service principal in sempy via fabric notebook? 

[bharathrs_nest]

Hi @lbendlin 

We have that SPN with tenant.readall permission set in Entra, the admin apis have a limitation of 50 requests per hour and we need to do a scan of more than 400+ workspaces.

[lbendlin · Accepted solution]

Batch your requests accordingly. Manage/correct expectations. This is a slow process by design.

[lbendlin]

you need to be tenant admin/capacity admin, and need to use the admin apis.  Allowing a service principal to do that is an auditing nightmare.