Question

You are an Analytics Engineer who wants to deploy a semantic model to a Fabric workspace using Tabular Editor via the XMLA endpoint. When you attempt to connect and save changes, the write operation fails even though the connection succeeds. You confirm your account has the Member role on the workspace. What must be configured to allow write operations through the XMLA endpoint?

Accepted Answer

In the Fabric admin portal, set the tenant setting 'XMLA endpoint' to allow, and set the workspace's XMLA Endpoint property to 'Read Write'.

Answer

Assign your account the Admin role on the workspace, because only Admins can write via XMLA.

Answer

Enable the 'Large semantic model storage format' setting on the semantic model before connecting.

Answer

Apply a sensitivity label to the semantic model so the endpoint permits authenticated writes.