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?
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.