I'm hoping I'm submitting a bug report the right way. I don't see an option for Power Query.
We had an error in a query that passed the wrong value to List.Dates. Part of what made the problem difficult to debug is that the error message is wrong. Here's the documentation on List.Dates:
List.Dates(start as date, count as number, step as duration) as list
Returns a list of date values of size count, starting at start. The given increment, step, is a duration value that is added to every value.
We passed a negative number to count and this is the error message:
= List.Dates(#date(2023,1,1), -10, #duration(1,0,0,0))
Expression.Error: The 'increment' argument is out of range.
It was not the 'increment' or step (1.00:00:00) that was the problem. It was the count being -10. The error message should say something like:
Expression.Error: The 'count' argument is out of range.
Hi @Rudz ,
This seems to be a problem caused by incorrect code, you can refer to the following threads to see if it helps.
Solved: The mess "Expression.Error: The 'Count' argument i... - Microsoft Power BI Community
excel - PowerQuery M Conditional Column 'count' argument is out of range - Stack Overflow
Solved: Re: The mess "Expression.Error: The 'Count' argume... - Microsoft Power BI Community
Here is the Power query forum and if you need further help you may try this forum.
Power Query - Microsoft Power BI Community
Community Support Team_ Caitlyn