XMLA endpoint issue

Hi Anonymous  ,

By default, Premium capacity or Premium Per User dataset workloads have the XMLA endpoint property setting enabled for read-only. This means applications can only query a dataset. For applications to perform write operations, the XMLA Endpoint property must be enabled for read-write.

To enable read-write for a Premium capacity

1. Click Settings > Admin portal.

2. In the Admin portal, select Capacity settings > Power BI Premium > capacity name.

3. Expand Workloads. In the XMLA Endpoint setting, select Read Write. The XMLA Endpoint setting applies to all workspaces and datasets assigned to the capacity.

With some tools, such as SQL Server Profiler, you must specify an Initial Catalog, which is the dataset (database) to connect to in your workspace. In the Connect to Server dialog, select Options > Connection Properties > Connect to database, enter the dataset name.

Unsupported datasets

The following datasets aren't accessible by using the XMLA endpoint. These datasets won't appear under the workspace in SSMS or in other tools:

• Datasets based on a live connection to an Azure Analysis Services or SQL Server Analysis Services model.
• Datasets based on a live connection to a Power BI dataset in another workspace. To learn more, see Intro to datasets across workspaces.
• Datasets with Push data by using the REST API.
• Datasets in My Workspace.

Excel workbook datasets.

More details: Dataset connectivity with the XMLA endpoint 

Troubleshoot XMLA endpoint connectivity 

Best Regards
Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.