Empty Date Column after publishing

Hi All

I have a report created in the desktop app. Its pulling data from a SQL server, including a couple of date/time fields, "Created Date" & "Approved Date". I have split these into two seperate columns each, one for the date, and one for the time, and then used the Created Date column to join onto my date table. This works as expected in the desktop app.

When I publish the report to my workspace, it looks like the Created Date and Time columns are empty, which is breaking a bunch of the visuals that im using. If I create a new report in app.powerbi.com and create some tables with just those values and no filters, Approved Date and Time work just fine, Created Date and Time are blank.

I have gone through the power query editor and the code is the same for the steps where i split and transform the columns. I have attempted to use Change Type with locale, but that has not resolved anything.

Anyone got any ideas?

#"Split Column by Delimiter" = Table.SplitColumn(Table.TransformColumnTypes(#"Expanded RequisitionStatus", {{"CreatedDate", type text}}, "en-AU"), "CreatedDate", Splitter.SplitTextByEachDelimiter({" "}, QuoteStyle.Csv, false), {"CreatedDate.1", "CreatedDate.2"}),
#"Changed Type with Locale" = Table.TransformColumnTypes(#"Split Column by Delimiter", {{"CreatedDate.1", type date}}, "en-AU"),
#"Changed Type" = Table.TransformColumnTypes(#"Changed Type with Locale",{{"CreatedDate.2", type time}}),
#"Renamed Columns" = Table.RenameColumns(#"Changed Type",{{"CreatedDate.1", "CreatedDate"}, {"CreatedDate.2", "CreatedTime"}}),

#"Split Column by Delimiter2" = Table.SplitColumn(Table.TransformColumnTypes(#"Renamed Columns1", {{"ApprovedDate", type text}}, "en-AU"), "ApprovedDate", Splitter.SplitTextByEachDelimiter({" "}, QuoteStyle.Csv, false), {"ApprovedDate.1", "ApprovedDate.2"}),
#"Changed Type2" = Table.TransformColumnTypes(#"Split Column by Delimiter2",{{"ApprovedDate.1", type date}, {"ApprovedDate.2", type time}}),
#"Renamed Columns2" = Table.RenameColumns(#"Changed Type2",{{"ApprovedDate.1", "ApprovedDate"}, {"ApprovedDate.2", "ApprovedTime"}})