Direct Query error

[Anonymous]

I have an oracle query as a source , I just added a column in "Edit Queries", this new column simply adds two existing columns from the query I loaded (new column = col 1 + col 2), where col1 and col2 are part of the query

when I close and apply, the changes are not being applied and I get the attached error, why is this

This Query contains transofrmations that can't be used for DirectQuery

[Anonymous]

I just applied a dax to add two existing columns, thats it

[v-eachen-msft]

Hi @Anonymous ,

You could check if col1 and col2 are the same number type data.

After my tests, it is available in the DirectQuery.

[Anonymous]

I cannot do any such additions or simple math in direct query mode ?