I am using the older excel add-in. I wasn't aware of the beta version. I'm not able to add the beta version at this time, my company has blocked the ability to add Add-Ins through the My Add-ins option.
I've tried multiple combinations of columns, filters/queries all result in the same error. Even just selecting
Type = Test Case Result
Order = Date
Columns = Verdict
I get the same error.
I have tried adding filters that work in my other queries to narrow the results down, that does not help either. I've also tried renaming the query so that it does not match the Type.