Api Explorer returning incorrect results

When querying the alj-pw.bentley.com server, the values returned for PW_STATE are incorrect.
We discovered this issue when doing a web call with Power BI - the PW_STATE was not displaying any of the "Superseded - ..." states.
I have some observations of the issue from when I've compared the web call results to a manual exported to excel
We are doing a web call to our ProjectWise server using Power BI. We are getting the web address to input into Power BI using your Api Explorer.