Enabling XMLA Read-Write Access in Microsoft Fabric

DP-600 By islever Editorial Last updated

Short answer

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

Question

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?
  1. the DS1 settings
  2. the WS1 settings
  3. the C1 settings Correct Answer
  4. the Tenant1 settings

Key Takeaways

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.

Common mistake: 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.

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

This link opens the official vendor documentation in a new tab.

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.

More DP-600 FAQ →

Community Votes

C
100%

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

Discussion 19 contributions

Compiled from public community threads and reader submissions, lightly edited for clarity. Handles and vote tallies are shown as recorded, and comments reflect the views of individual contributors.

From public community threads 19

  1. a_51 👍 25 Answered 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
  2. STH 👍 11 Answered 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.
  3. 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.
  4. Jons123son 👍 3 Answered 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.
  5. wojciech_wie 👍 3
    C1 https://learn.microsoft.com/en-us/power-bi/enterprise/service-premium-connect-tools
Show 14 more comments
  1. metiii 👍 2 Answered 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
  2. 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
  3. VAzureD 👍 2 Answered D
    we need to first configure tenant settings: Allow XMLA endpoints and Analyze in Excel with on-premises semantic models:
  4. 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
  5. 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.
  6. emmanuelkech 👍 1 Answered 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.
  7. Rezako 👍 1 Answered 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
  8. Charley92 👍 1 Answered 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
  9. stilferx 👍 1 Answered 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"
  10. 6d1de25 👍 1 Answered 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.
  11. XiltroX 👍 1
    C is the right answer. The read/write permission is set in capacity settings in Admin Portal.
  12. NRezgui 👍 2 Answered C
    the C1 settings
  13. Nerd_Remo 👍 2
    C1 is Correct.
  14. Momoanwar 👍 1 Answered C
    First check on capacity level

Reader comments & corrections

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

Log in to comment, report an error, or add a note about this question.

Fabric Deployment Pipeline Folder Structure Behavior

S-grade

Accessing OneLake Shortcuts in Fabric Notebooks

S-grade

Direct Lake Fallback to DirectQuery with Row-Level Security

S-grade

Displaying All Rows in Power BI Python Visuals

S-grade

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