Forum Discussion

johnlhaase's avatar
johnlhaase
Icon for Helper I rankHelper I
6 years ago
Solved

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

Hello   I am trying to get my report refreshed and I keep getting this error while using Gateway. I went back into my query to see if there is a questionable reference to a table and I cannot find ...
gateway
Refreshing
  • johnlhaase's avatar
    johnlhaase
    5 years ago

    Hello

     

    After a significant amount of time trying to find the error. I went back and re-read the meassage which refered to the table it was having an issue with. Although I check this table several time it ended up being the culprit. The table is imported as a CSV with several blank rows before the header. I had slipped in a data change to a column prior to "Using First Row as Header" which casued the issue. Always remember to read the error message closely since its the clue to the problem!!!!

     

    Thanks for your help.

     

    John Haase

    aka Johnny X

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
6 years ago

johnlhaase - 

DateRange = 
  IF( 
    DAY(Population[Date] ) = DAY(TODAY()),
    "Current Date", 
    DAY(TODAY())-DAY(Population[Date]) & " Day(s) Ago"
  )
johnlhaase's avatar
johnlhaase
Icon for Helper I rankHelper I
5 years ago

Hello

 

After a significant amount of time trying to find the error. I went back and re-read the meassage which refered to the table it was having an issue with. Although I check this table several time it ended up being the culprit. The table is imported as a CSV with several blank rows before the header. I had slipped in a data change to a column prior to "Using First Row as Header" which casued the issue. Always remember to read the error message closely since its the clue to the problem!!!!

 

Thanks for your help.

 

John Haase

aka Johnny X