Forum Discussion
Helper I5 arguments were passed to a function which expects between 2 and 4
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
Helper IBelow is the Data Source Error.
I also have this DAX Column
{"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","pbi.error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"5 arguments were passed to a function which expects between 2 and 4."}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.Arguments","detail":{"type":1,"value":"{Table.FromRecords({}), \"Index\", 1, 1, number}"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"Expression.Error"}}],"exceptionCulprit":1}}} Table: Crew Flights Information.
Community ChampionDateRange =
IF(
DAY(Population[Date] ) = DAY(TODAY()),
"Current Date",
DAY(TODAY())-DAY(Population[Date]) & " Day(s) Ago"
)- johnlhaase
I do not see you solution. Did you send one?
John
- johnlhaase
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