Direct Query Oracle transformations

[BrianPBI37QF]

Hi all,
I am unable to create any transformations/applied steps (Ive tried very simple (Change type, fill down, etc) and more complex transformations such as (split column) with a Direct Query from an Oracle server":

let
    Source = Oracle.Database("XXX:1526/XXX", [CreateNavigationProperties=false]),
    Query1= Source{[Schema="XXXX",Item="XXXXX"]}[Data]
in
    Query1

But keep getting the following message, doesnt matter what transformation I do:

I am aware that some transformations is not supported by Direct Query but Im not aware that non can be applied.
Thanks!
John

[BA_Pete]

Hi John,

While it may seem that the transformations you've tried are 'simple', Direct Query will only accept transformations that translate directly into the Source's native SQL.

Fill Down, for example, has no direct translation to an Oracle SQL function (as far as I'm aware). Additionally, changing data types to text and to integer tends to break folding on all SQL sources.

Try doing a simple Group By on your table (a function that has direct SQL equivalents in all SQL variants) and see how you get on. You can also try adding a new custom column that is just = "TEST". My guess is that both of these transformations will work fine.

Pete