Forum Discussion
PL-300 question
- 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
- 18 days ago
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
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