Forum Discussion
Error tracing problem
I have a query in the PQE. All column stats look something like this, i.e. zero errors: In the PQE grid, the data looks how I expect it to look. Some blanks and some values. No errors. ...
This is solved already but I thought I would leave it up here for others to see. The query UI had inserted this, but not updated it when I changed the column type:
= Table.Group(#"Removed Other Columns", {"Serial", "Episode"}, {{"MaxCIRHEPCTest", each List.Max([CIRHEPCTSTD]), type nullable datetime}, {"MaxCIRHIVTest", each List.Max([CIRHIVTESTDT]), type nullable text}})What gets me is why this was enough to break several things like copy/paste or report load, but not the PQE grid. My best chance of figuring out what was wrong was telling me everything was fine.
This is solved already but I thought I would leave it up here for others to see. The query UI had inserted this, but not updated it when I changed the column type:
= Table.Group(#"Removed Other Columns", {"Serial", "Episode"}, {{"MaxCIRHEPCTest", each List.Max([CIRHEPCTSTD]), type nullable datetime}, {"MaxCIRHIVTest", each List.Max([CIRHIVTESTDT]), type nullable text}})What gets me is why this was enough to break several things like copy/paste or report load, but not the PQE grid. My best chance of figuring out what was wrong was telling me everything was fine.