top of page
  • Writer's pictureMarkDataGuy

Tabular - PowerQuery - 5 arguments were passed to a function which expects between 2 and 4

Hi There,


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.


Cheers


Mark


1,411 views2 comments

2 commenti


jose.bressan
02 lug 2021

For some reason the last argument is causing this error, I remove it and is working fine. Table.AddIndexColumn(#"Grouped Rows", "Index", 1, 1, Int64.Type) Table.AddIndexColumn(#"Grouped Rows", "Index", 1, 1)

Mi piace
MarkDataGuy
MarkDataGuy
07 lug 2021
Risposta a

Good to know. Thanks Jose.

Mi piace
bottom of page