The column 'Date Offset' in table 'Date' has invalid bindings specified

by Neil P   Last Updated August 15, 2017 11:06 AM

I'm trying to deploy a tabular model to a server using the "Analysis Services Deployment Wizard".

When attempting to deploy,I get the below error.

The JSON DDL request failed with the following error: Failed to execute XMLA. Error returned: 'The column 'Date Offset' in table 'Date' has invalid bindings specified.

The column in question uses the below calculation, which was found here

INT([Date] - TODAY())

What should I look for in order to resolve this error?

Answers 1

The problem in this case was that I was trying to replace an existing column also named 'Date Offset' - this was not a calculated column, but taken from the source table.

Resolution was to do the deployment in 2 phases, first remove the old column, then deploy again to add the new calculated column.

Neil P
Neil P
August 15, 2017 10:57 AM

Related Questions

How make an SSAS Tabular model case sensitive?

Updated August 10, 2017 10:06 AM