microsoft / semantic-link-labs

Early access to new features for Microsoft Fabric's Semantic Link.
MIT License
179 stars 41 forks source link

BPA for all semantic models fails if user has access to Admin Monitoring workspace #186

Open DhyanRathore opened 1 month ago

DhyanRathore commented 1 month ago

Describe the bug The semantic model best practice analyzer across all accessible workspaces run_model_bpa_bulk(workspace=None) fails if the user can access the Fabric Admin Monitoring workspace. By default, the admin monitoring workspace is assigned to a shared capacity, and moving it to a Fabric capacity didn't work either.

To Reproduce

  1. Ensure you have access to the Admin Monitoring workspace
  2. In a Fabric notebook, run the semantic model bpa without specifying a workspace (workspace=None) or the following snippet
    %pip install semantic-link-labs
    import sempy_labs as labs
    import sempy_labs.report as rep
    labs.run_model_bpa_bulk(workspace=None)

Expected behavior The command should execute successfully, and BPA stats for all the workspaces to which the user has access should be available in the lakehouse table. Alternatively, the Admin Monitoring workspace should be excluded from the scan.

Screenshots Admin Monitoring on Fabric Capacity

Desktop (please complete the following information):

Additional context We do not have the option to turn off the Admin Monitoring workspace. So Fabric Administrators and users with access to the Admin Monitoring workspace can't use the workspace=None unless this behavior has been fixed.