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

Anonymous — Thu, 22 Oct 2020 08:59:55 GMT

Hi,

I have a report which doesn't refresh in Powerbi web having a gateway connection to a PostGreSQL database which works fine with other reports. Please note that this report does refresh in the desktop version without any problem.

I am getting the following technical details, which doesn't really help me to find at least the name of the table that may cause the error (I guess that the problem is linked to tables, having also read the message https://community.powerbi.com/t5/Report-Server/5-arguments-were-passed-to-a-function-which-expects-between-2/td-p/1358466).

Unable to connect to the data source undefined.

Underlying error code-2147467259
Underlying error message5 arguments were passed to a function which expects between 2 and 4.
DM_ErrorDetailNameCode_UnderlyingHResult-2147467259
Microsoft.Data.Mashup.ValueError.Arguments{Table.FromRecords({}), "Index", 1, 1, number}
Microsoft.Data.Mashup.ValueError.ReasonExpression.Error

Can you please help?

Thanks,
Salva

Re: 5 arguments were passed to a function which expects between 2 and 4

Anonymous — Thu, 22 Oct 2020 09:29:31 GMT

Solved after reading this https://community.powerbi.com/t5/Desktop/Add-Index-Function-causes-refresh-to-fail/td-p/1301932.

The root cause was the adoption of an index. I have just erased the column type and now the refreshes.

topic Re: 5 arguments were passed to a function which expects between 2 and 4 in Report Server

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

Re: 5 arguments were passed to a function which expects between 2 and 4