Comprehensive Detailed Explanation
Step 1: Default permissions when sharing a warehouse in Fabric
When you share a Fabric warehouse (DW1) with a user and assign them default permissions, the user:
Gets Build permission by default.
Build permission allows the user to:
Use the default dataset automatically created for the warehouse.
Build reports and dashboards against that dataset.
It does not grant direct query permissions to the underlying tables or files.
Step 2: Analyze the options
A). Build reports by using the default dataset. #
Correct. Sharing a warehouse gives Build permission on the warehouse's default dataset.
User1 can create Power BI reports but cannot directly query the warehouse via SQL.
B). Read the underlying Parquet files from OneLake.
Incorrect. Access to underlying OneLake files requires Direct Lake storage access or shortcut permissions, not provided by default sharing.
C). Connect to DW1 via the TDS endpoint.
Incorrect. The TDS endpoint is supported by semantic models, not warehouses.
D). Read data from the tables in DW1.
Incorrect. Default permissions do not allow table-level SQL access. They allow using the dataset for reporting.
Step 3: Correct Answer
The only capability User1 has by default is:
A). Build reports by using the default dataset.
References
Fabric warehouses - permissions
Build permission in Power BI