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 basis.
Now, in PBI we have setup "Rangestart and Rangeend" parameters and we have defined incremental refresh policy for the tables.
on-premises data gateway (personal mode) and have scheduled a refresh (everyday basis) however we have getting an error. Kindly look into and provide your help to sort our this issue on priority.
Attached error screenshot for your review and this is PowerBI Pro version desktop query. Kindly help
3 Replies
Since you had already apply for incremental refresh don't refresh the report directly on service.
first publish the report on service > use tabular editor and apply reresh policy that will create the partition for the table then refresh each partition one by one and then apply report refresh from power bi service.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.
