Enabling XMLA Read-Write Access in Microsoft Fabric

Answer Correct answer: C — You must modify the capacity settings (C1) to change the XMLA endpoint configuration from read-only to read-write access.

You have a Fabric tenant named Tenant1 that contains a workspace named WS1. WS1 uses a capacity named C1 and contains a dataset named DS1. You need to ensure read-write access to DS1 is available by using XMLA endpoint. What should be modified first?

the DS1 settings
the WS1 settings
the C1 settings Correct Answer
the Tenant1 settings

power bi xmla read write microsoft fabric capacity settings dp-600 xmla endpoint enable xmla read write access

Community Votes

100%

100% of anonymous learners picked answer C. Votes are pick records left by other test-takers — they are not the verified answer.

Community Insight

The exam tests the distinction between enabling the XMLA feature (tenant level) and configuring its access mode (capacity level), with the common trap being confusion over which layer controls read-write permissions.

This question addresses how to configure read-write access to a dataset via the XMLA endpoint in Microsoft Fabric. It establishes that capacity-level settings must be modified to switch from read-only to read-write connectivity.

Many candidates select D (Tenant1 settings) because they believe tenant configuration is the prerequisite step. However, since the XMLA endpoint is already implied to be active, the specific action for read-write access lies at the capacity level.

Community Discussion (20 comments)

a_51 👍 25 Selected: C

As XMLA is set to Read-Only first, you must go to the capacity settings to enable read-write. https://learn.microsoft.com/en-us/power-bi/enterprise/service-premium-connect-tools#enable-xmla-read-write

STH 👍 11 Selected: C

The question concerns changing from read-only to read-write (in the Capacity settings), not about enabling XMLA endpoints (in the Tenant settings), which, as per the query, are already set up.

NRezgui 👍 2 Selected: C

the C1 settings

Charley92 👍 1 Selected: C

The XMLA endpoint in Microsoft Fabric allows read-write operations for datasets. To enable read-write access, you must first configure the capacity settings (C1 in this case) to allow XMLA read-write connectivity

Rakesh16 👍 1 Selected: C

the C1 settings

jass007_k 👍 2

Correct answer is option C) R/W settings of XMLA endpoint is done under capacity settings by fabric admin. By default, read-only connectivity using the endpoint is enabled for the Semantic models. Link for reference: https://learn.microsoft.com/en-us/power-bi/enterprise/service-premium-connect-tools#enable-xmla-read-write

6d1de25 👍 1 Selected: C

Correct answer is C https://learn.microsoft.com/en-us/power-bi/enterprise/service-premium-connect-tools#:~:text=To%20enable%20read,to%20the%20capacity.

momo1165 👍 1

Enable XMLA read-write: Select Settings > Admin portal. In the Admin portal, select Capacity settings > Power BI Premium > capacity name. Expand Workloads. In the XMLA Endpoint setting, select Read Write. The XMLA Endpoint setting applies to all workspaces and semantic models assigned to the capacity.

Rezako 👍 1 Selected: C

The right answer is C, You use tenant setting to Allow XMLA endpoints and Analyze in Excel with on-premises datasets. It is read only access but with Capacity settings you can choose between off, read only and read-write

Jons123son 👍 3 Selected: D

The questions asked what should be modified FIRST. Therefore, I would go with D because C requires that D is activated. Although, I am not sure if D is not activated by default, thus making C the ONLY modification required. I hate it when MS exam questions leave room for interpretation. Why don't they ask for two answers... Weirdly enough Questions 21 covers basically the same topic and there people agree that Tenant settings are definitely required next to capacity settings.

282b85d 👍 1

To ensure read-write access to a dataset (DS1) using the XMLA endpoint in your Fabric tenant, you need to modify the settings that control XMLA endpoint access. This typically involves enabling read-write capabilities for the XMLA endpoint at the capacity level. Therefore, you should modify: C. the C1 settings

stilferx 👍 1 Selected: C

IMHO, the answer is C. As described here: https://learn.microsoft.com/en-us/power-bi/enterprise/service-premium-connect-tools#enable-xmla-read-write in the section "To enable read-write for a Premium capacity"

VAzureD 👍 2 Selected: D

we need to first configure tenant settings: Allow XMLA endpoints and Analyze in Excel with on-premises semantic models:

emmanuelkech 👍 1 Selected: B

To ensure read-write access to the dataset DS1 via the XMLA endpoint, you should modify the settings at the workspace level (WS1). Specifically, enable read-write operations for the XMLA endpoint within the workspace configuration.

thuss 👍 4

Again, bad wording in the question. If it is specifically about read-write, it's C. If it's about having XMLA endpoints available in the first place, it's D. Judging by Microsoft's wordings and ways of referring to their own documentation, I guess they want us to go for C.

metiii 👍 2 Selected: D

We need to configure several settings but in terms of hierarchy we need to first configure tenant settings: Allow XMLA endpoints and Analyze in Excel with on-premises semantic models: Users in the organization can use Excel to view and interact with on-premises Power BI semantic models. This also allows connections to XMLA endpoints. https://learn.microsoft.com/en-us/fabric/admin/tenant-settings-index

XiltroX 👍 1

C is the right answer. The read/write permission is set in capacity settings in Admin Portal.

Momoanwar 👍 1 Selected: C

First check on capacity level

wojciech_wie 👍 3

C1 https://learn.microsoft.com/en-us/power-bi/enterprise/service-premium-connect-tools

Nerd_Remo 👍 2

C1 is Correct.

Comments & Corrections

No comments yet — spotted an error or have a note? Share it below.

Expert Analysis

Why the Answer Is Correct

Read-write access to datasets via the XMLA endpoint in Microsoft Fabric is controlled by the capacity settings. By default, Premium capacities often have XMLA endpoints enabled but set to read-only to protect data integrity. To allow write operations (such as DirectQuery updates or Import mode refreshes via external tools), you must modify the specific capacity (C1) settings to enable 'XMLA read-write' connectivity.

Why the Other Options Are Wrong

Option D (Tenant1 settings) is incorrect because it governs global features like whether the XMLA endpoint is available to the organization at all. Since the question implies the endpoint exists and focuses on 'read-write access', the tenant setting is not the primary modifier here. Options A (DS1 settings) and B (WS1 settings) are incorrect because XMLA access modes are inherited from the capacity and cannot be overridden at the dataset or workspace level.

Community Comment Notes

The community largely agrees with C, noting that while tenant settings enable the feature, capacity settings control the read-write state. One commenter noted that if the endpoint were not enabled at all, D would be first, but for read-write specifically, it is C. Another user highlighted that this is a common point of confusion in Microsoft's documentation wording.

Official Reference

https://learn.microsoft.com/en-us/power-bi/enterprise/service-premium-connect-tools#enable-xmla-read-write

Exam Strategy

When asked about 'read-write' vs 'read-only' access for XMLA, always look to the Capacity settings first. If the question asks about enabling the endpoint itself for the organization, look to Tenant settings.

Frequently Asked Questions

Why isn't the Tenant setting the first step?

Tenant settings enable the XMLA endpoint globally. Since the endpoint is already present, the specific read-write toggle is managed at the Capacity level.

Can I enable read-write on a specific dataset?

No. XMLA read-write access is a property of the Capacity hosting the dataset, not individual datasets or workspaces.

Related Analysis

Practice All DP-600 Questions

Access 115 questions with complete answers and detailed explanations.

View Full DP-600 Practice Test →

← Back to DP-600 Study Guide