How to Limit rows from Oracle source

Venkat_Thota 

You can follow this synatx then:

let
DEVQUery = "select * from some_table fetch first" &  parameterName  &"rows only",
PRODQuery = "select * from some_table",
Query = if parameterName = 5000 then DEVQUery else PRODQuery,
Source = Oracle.Database(Server, [Query=Query])
in 
Source

From service you can change the parameter value to anything but 5000. then you will be able to to do the full load.

please be informed you need to keep the parameter data type as whole number. 

Need a Power BI Consultation? Hire me on Upwork

Connect on LinkedIn

Did I answer your question? Mark my post as a solution! If I helped you, click on the Thumbs Up to give Kudos. Proud to be a Super User!