QuestionQ194

Maintain a data analytics solution

You have a Fabric tenant that contains a workspace named Workspace1 and a user named User1. Workspace1 contains a warehouse named DW1.

You share DW1 with User1 and assign User1 the default permissions for DW1.

What can User1 do?

  • A Read data from the tables in DW1.
  • B Build reports by using the default dataset.
  • C Read the underlying Parquet files from OneLake.
  • D Connect to DW1 via the TDS (Tabular Data Stream) endpoint.
Explanation

By default, sharing a warehouse grants only the base Read permission, which allows connecting via the SQL analytics endpoint's TDS-based connection string but not querying tables (ReadData), building reports on the default semantic model, or reading the raw OneLake Parquet files — those all require explicitly selecting the corresponding additional permission when sharing.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!