3

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?

Neil P
  • 1,294
  • 3
  • 20
  • 38

5 Answers5

4

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
  • 1,294
  • 3
  • 20
  • 38
0

I was able to solve this by deleting the cube completely off of the server before doing another deploy.

Lucky
  • 131
  • 1
  • 1
  • 5
0

Tried different methods like renaming column and removed filters applied, didn't solved this issue. At the end this issue fixed by just deleting existing cube and redeployed

rchacko
  • 298
  • 2
  • 7
0

In my case, I remove duplicated columns and the error persisted.

It only worked when I did delete model in azure --> analysis services.

Laurenz Albe
  • 61,070
  • 4
  • 55
  • 90
Bruno Campos
  • 101
  • 1
0

So I had this error and I was able to resolve it by deleting the column from the model.bim. You have to be careful and make a copy of the model.bim before you start making changes. Then I created the calculated column and gave it a new name and it worked fine.

I hope my answer helps others.

John K. N.
  • 18,854
  • 14
  • 56
  • 117
khouloud IBN HADJ
  • 1
  • 1