PowerQuery_2.34 vs. PowerQuery_2.25

GusGarcia — Fri, 01 Jul 2016 11:35:56 GMT

At the suggestion of an update pop-up, I downloaded and installed PowerQuery_2.34 (after removing PowerQuery_2.25) and several of my formerly working queries were failing. I narrowed the issue down to any in-stream numeric/date data manipulation:

filtering of a date/time field to restrict the data pull (e.g. Table.SelectRows(MyBiz, each Date.IsInCurrentDay([SnapDate])) )
[Note: SnapDate comes in as date-time format (mm/dd/yy hh:mm:ss) and is tagged as a date field in the header.]
type conversion of a date/time field to date (e.g. Table.TransformColumnTypes(Latest,{{"SnapDate", type date}}) )
[Note: values are replaced by "Error".]
Adding an calculation column (e.g. Table.AddColumn(#"Add Data Items", "AllQty", each [Billing Qty]+[Backlog Qty]) )
[Note: values are replaced by "Error".]

Each/all of these manipulations caused all subsequent operations, and of course the query, to fail - even if I tried re-creating the original query and filters from scratch. Furthermore, the data-type icons appearing at the top of the data preview columns (which start out okay), go haywire with even the simplest filter request on numeric or date fields.

I uninstalled v2.34 and re-installed v2.25 and all my workbooks and queries worked again.

Please advise if there's a bug fix for this so I can get back to the supposed benefits of the latest version.

Respectfully,

Gus

topic PowerQuery_2.34 vs. PowerQuery_2.25 in Developer

PowerQuery_2.34 vs. PowerQuery_2.25