this step results in a query that is not supported in directquery mode error with custom query

[sheetalshettiga]

Hi all ,

I am using a direct Query mode to connect to oracle db with sql statement : select * from ORDERS

In the power query editor when I try to rename ORDER_ID column to ORDER_NO it shows me 'this step results in a query that is not supported in directquery mode'

I cannot add a new column or change data type aswell.But without sql query and choosing directquery mode I can perform all the transformations

Below is the MQUERY:

let
Source = Oracle.Database("localhost:1521/orcl", [HierarchicalNavigation=true, Query="select * from ORDERS"]),
#"Renamed Columns" = Table.RenameColumns(Source,{{"ORDER_ID", "ORDER_NO"}})
in
#"Renamed Columns"

[v-chuncz-msft]

@sheetalshettiga 

You may take a look at the link below.

https://docs.microsoft.com/en-us/power-query/native-database-query#query-folding