I’m kicking myself for not testing my PowerBI & Excel reports in Pilot ahead of the 2023 public cloud update last weekend. The last couple days I have had a couple users tell me their dates are showing up a day behind (6/13 is showing as 6/12).
I am not sure if it was a change in the Epicor Schema, or the way REST API pulls the JSON, but now when I pull the BAQ(in kinetic) records shows: 2023-06-13T00:00:00 when I pull the BaqSvc through the web browser the json shows: 2023-06-12T18:00:00-06:00, and when power query gets the JSON it shows: 2023-06-12T00:00:00-05:00.
So, the moral of the story if you use Odata REST connection in Kinetic 2023, You will need to either fix the dates on the BAQ side, or on the external app side. See below for fix in Power Query:
In “Advanced Editor” add the following line to the bottom of the code(this assumes you have already converted your columns to the correct types)
let
#Previous Lines
#“Line Label” = Table.TransformColumns(#“Line Label of Prev. Line”, {{“Date Column Name”, each Date.AddDays(DateTime.Date(_), 1), type date}}),
#Add Line for Each Date Column
in
#“Last Line Label”