Forum Discussion

powerbidev123's avatar
powerbidev123
Solution Sage
19 days ago
Solved

PL-300 question

You have a Microsoft Fabric tenant that contains a warehouse named WH1. You share WH1 with default permissions to a user named User1. What will User1 be able to do? Select only one answer. Connect to...
  • Shai_Karmani's avatar
    18 days ago

    The correct choice here is "Connect to WH1."

     

    When you share a Fabric warehouse with default permissions and no additional options checked, the recipient only gets Read on the warehouse item itself. That grants the ability to see it and connect to the SQL analytics endpoint (the equivalent of CONNECT in SQL Server), but not to query any table or view.

     

    To let User1 also query data, build reports on the default semantic model, or read the OneLake Parquet files, you would need to check the extra options at share time (Read all SQL endpoint data, Build reports on the default semantic model, Read all data using OneLake), or grant object-level permissions via T-SQL GRANT.

     

    If this helped, a thumbs up and accepting the solution would be appreciated.

     

    Best,

    Shai Karmani

  • krishnakanth240's avatar
    18 days ago

    Hi powerbidev123 

    Build reports on the default semantic model for WH1.

    When you share a warehouse with default settings, both Read and Build reports on the default semantic model are checked by default and Build is the option selected

    Build reports on the default semantic model grants Build permission and letting user create Power BI reports on the warehouse's default model and selected by default when sharing