URGENT - Incremental Refresh in Service

[ApoorvaReddy]

Hi,

1) We would like to know if Incremental refresh can update any historical record placed in time that got changed as of last refresh and will it create a new duplicate record or just update it.

2) Can Incremental Refresh be applied to odbc.query coz i do not see view native query enabled in applied steps and does it mean query folding is not occuring ?

3) After i apply incremental refresh and published to service cloud, my custom parameters passed in odbc.query are not shown in dataset settings. I have 3 parameters and all are missing.

Appreciate any inputs !

[lbendlin]

1. Head over to the ideas site and vote for the idea to allow force refresh of a dataset that is set to incremental.

2. It depends.  You need to play with your Power Query code. Sometimes it works (Table.ExpandColumn) sometimes it doesn't (Table .Combine)

3. that sounds like a bug - you may want to raise that.