Problems with calculated date field. Difference between imported data and direct connected data sour

I'm having problems with a formula that works perfectly fine for an imported dataset, but does not work for the same dataset when it's being direct imported via powerquery from d365.

Screenshots of the custom column formula attached. It works perfectly fine with the data from the import, but errors on the direct connected data. Both are coming from the exact same table in d365.

I've also noticed that Created On column from the power query report does not come with the built-in hierarchy, whereas the imported data has the hierarchy already created.