Forum Discussion
How to Limit rows from Oracle source
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 SourceFrom 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!
Sorry...I am not clear on your solution. On PBI Service, I wanted to do a full load, how your logic work on service. By changing number, I can increase the no of rows to load. YOu mean to say I have to give a big number like total no of rows. For example my table is having 30M records then I have to give 30M as the parameter value.
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
SourceFrom 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
|