Facing a issue in deploying XMLA Endpoint

[Anonymous]

Hi Team,

we are trying to deploy a metric using XMLA endpoint from Tabular editor. While adding deploy we are facing the below error as per the attachment.

Thanks & Regards,
Pavithra

[Anonymous · Accepted solution]

Hi @Anonymous ,

Thank you for providing the error message. The error message "Table 'nyctlc' cannot have more than one partition when entity partition is present" indicates that there is an issue with the partitioning of the table 'nyctlc' in your deployment. To resolve this issue, you can follow these steps:

1. Open the Tabular editor and connect to your Analysis Services instance.

2. Locate the table 'nyctlc' in the model.

3. Check if there is an entity partition defined for this table. If there is, you need to ensure that there is only one partition for this table.

4. If there are multiple partitions defined for the table, you will need to remove the additional partitions.

5. Right-click on the table and select "Partitions" to view and manage the partitions.

6. Remove any additional partitions that are present for the 'nyctlc' table, leaving only one partition.

7. Save the changes in Tabular editor.

8. Retry the deployment using the XMLA endpoint.

By following these steps, you might be able to resolve the issue and successfully deploy the metric using the XMLA endpoint.

Best Regards,

Stephen Tao

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