XMLA endpoint issue

[karthikaganesh]

I'm working on powerbi report builder. My dataset is too large so I'm trying to get data using xmla endpoint. It is not working. I tried the same credentials in mirosoft sql server management studio. It is working fine. But in Report builder its not working.

While choosing the data source as Microsoft SQl in data source properties and Azure analysis service in Connection properties, Test connection succeeded.

WHile the data source is Azure analysis service in connection properties and microsoft sql service analysis in data source properties, Test connection succeeded in that level

But testing in data source properties showing this below error.

After closing the connection properties tab and testing connection in data source properties. It is showing error.

When giving the same data source name showing error in connection properties.

If the data source is same in data source properties and connection properties it is showing error like this

When both are Azure analysis service showing error.

if both data sources are azure analysis serivie again showing error

when Data source is azure analysis service in data source properties and microsoft sql server analysis in connection proprties, Test connection succeeded.

while giving different name not showing error in connection property level

But after testing in data source properties, showing error.

but showing error in data source property tab

Really I'm confused, how to connect through XMLA Endpoint. Can anyone help me with this.

Thank you.

[Chandani_Harshi]

@amitchandak I am trying to connect SSMS with XMLA endpoint, After changing the XMLA endpoint to read/write from capacity settings. I am getting this error. 

How would I solve this error ?

[AzizQuazi]

Hi @amitchandak , Is it possible to establish a connection between DAX Studio and XMLA endpoints within a Fabric Trial capacity? Thanks in advance.

[Anonymous · Accepted solution]

Hi @karthikaganesh  ,

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.

[AzizQuazi]

Is it possible to establish a connection between DAX Studio and XMLA endpoints within a Fabric Trial capacity?

[amitchandak]

@karthikaganesh , XMLA End point needs to need to be enabled from Admin Portal and also you need to set Red/Write from capacity setting.

Discussed here

Data Refresh using SQL Server Management Studio: https://youtu.be/kyCnnpjOwpI

[AzizQuazi]

@amitchandak, Is it possible to connect DAX Studio and XMLA endpoints within a Fabric Trial capacity? I appreciate any help you can provide.