Question
You have a Fabric tenant that contains a workspace named Workspace1. Workspace1 is assigned to a Fabric capacity.
You need to recommend a solution to provide users with the ability to create and publish custom Direct Lake semantic models by using external tools. The solution must follow the principle of least privilege.
Which three actions in the Fabric Admin portal should you include in the recommendation? Each correct answer presents part of the solution.
- A. From the Tenant settings, set Allow XMLA Endpoints and Analyze in Excel with on-premises datasets to Enabled. Correct
- B. From the Tenant settings, set Allow Azure Active Directory guest users to access Microsoft Fabric to Enabled.
- C. From the Tenant settings, select Users can edit data model in the Power BI service.
- D. From the Capacity settings, set XMLA Endpoint to Read Write. Correct
- E. From the Tenant settings, set Users can create Fabric items to Enabled. Correct
- F. From the Tenant settings, enable Publish to Web.
Explanation
External tools such as Tabular Editor create and publish semantic models through the XMLA endpoint, so the tenant setting that allows XMLA endpoints must be enabled and the capacity's XMLA Endpoint must be set to Read Write. Direct Lake semantic models are Fabric items, so users also need the Users can create Fabric items tenant setting. Guest access and Publish to Web are unrelated and would grant unnecessary access, and editing data models in the Power BI service is about web modeling, not external tools.
