Power Query: Non-negative Number required RRS feed

  • Question

  • Hello,

    My organization uses Power Query frequently to run one of our reports. This report involves merging several queries, appending a couple, each originating from one SQL server. The issue I've been running into has not been appending...but rather I received this error message ("Unexpected error: Non-negative number required. Parameter name: value etc etc--would post a screenshot but my account isn't verified yet) when I try to expand one of my merged queries (by one column, mind you).

    This issue has never been present previously...we run this report each month, and have never had an issue until now. Furthermore, I have checked the data and can confirm that there's no negative numbers (the column I am expanding does have negative values, but that has always been the case and nothing about this month's data leads me to believe that's an issue). 

    Thursday, October 17, 2019 2:13 PM