Forum Discussion
PowerBI Incremental Refresh in SQL Oracle
Hello All, We have imported query from Oracle SQL Server which has approximately 10Lakhs records on weekly basis. We have to do a sceduled refresh everyday and it has to be on incremental date ba...
Thanks and we have not implemented direct refresh. However, my Oracle SQL database is a custome SQL Statement and view native query has been gradeout, will it be still possible to do incremental refresh?
Yes you can still do incremental refesh
add a date filter in where condition of your custom sql query
lets say
select * from table
where your dateColumn >= Sdate and Datecolumn < EDate
here Sdate and EDate will be the value of start and end date
now insert this query in power query
and create the RangeStart and RangeEnd Parameter
now open the Advance editor of the above query and replace the date value with the parameter for RangeStart and RangeEnd
"&DateTime.ToText(RangeStart,"MM-dd-yyyy")&"
and then click done.