Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Next up in the FabCon + SQLCon recap series: The roadmap for Microsoft SQL and Maximizing Developer experiences in Fabric. All sessions are available on-demand after the live show. Register now

Reply
BartHuls
Helper I
Helper I

How can I set the Capacity Settings of a Semantic model by code

I want to set the Capacity Settings of a Semantic model by code. How can I do this, 

in this case to set the XMLA Endpoint to Read/Write

BartHuls_0-1744186754769.png

 

 

1 ACCEPTED SOLUTION

If you provide me a working answer then I will accept it not some copy paste from the first google search

View solution in original post

4 REPLIES 4
v-saisrao-msft
Community Support
Community Support

Hi @BartHuls,
Thank you for reaching out to the Microsoft Fabric Forum Community.

 

As of now, Power BI does not support modifying the XMLA Endpoint access mode via REST API, PowerShell, or any other automation method. This setting is scoped at the capacity level (not the dataset level) and must be updated manually by a Power BI Service Administrator in the Admin Portal. 

Submit your idea to Microsoft. If you get enough votes, they may consider in future. Raise your idea here 
[Submit Your Idea]

 

If this post helps, then please give us ‘Kudos’ and consider Accept it as a solution to help the other members find it more quickly.

 

Thank you. 

Deku
Super User
Super User

You can update tenant settings with the fabric API

 

https://learn.microsoft.com/en-us/rest/api/fabric/admin/tenants/update-tenant-setting?tabs=HTTP


Did I answer your question?
Please help by clicking the thumbs up button and mark my post as a solution!

If you provide me a working answer then I will accept it not some copy paste from the first google search

Hi @BartHuls,
I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, please Accept it as a solution and give it a 'Kudos' so others can find it easily.
Thank you.

Helpful resources

Announcements
New to Fabric survey Carousel

New to Fabric Survey

If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.

FabCon and SQLCon Highlights Carousel

FabCon &SQLCon Highlights

Experience the highlights from FabCon & SQLCon, available live and on-demand starting April 14th.

March Power BI Update Carousel

Power BI Community Update - March 2026

Check out the March 2026 Power BI update to learn about new features.