Tabular - PowerQuery - 5 arguments were passed to a function which expects between 2 and 4
This is a quick and easy one, related to differences in PowerQuery between PowerBI and when you create a Tabular Model in Visual Studio. I was recently working on a Tabular model and had cause to use an Index column in my Tabular PowerQuery. All works fine in Visual Studio and the data loads to Visual Studio. I then when to deploy to my Tabular Server and process the model and encountered the following error.
"The JSON DDL request failed with the following error: Failed to execute XMLA. Error returned: 'OLE DB or ODBC error: [Expression.Error] 5 arguments were passed to function which expects between 2 and 4.."
It turns out that the issue was with my Index Column that I had added to my Query. Once I removed and redeployed, my model processed without any difficulty.
I hope this helps someone.