Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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"
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.