Setting up incremental refresh up, Parameter selection in grey

[Vinod_G_245]

Hi Team, 

               I'm trying to setup incremental refresh, in query editor I created RangeEnd and RangeEnd two paramenters in Setup these parameters in Query I'm not able to select the option parameter,

Please find Attached screen shot for clear understanding. (Parameter is not showing for selection)

Thanks,

Vinod G

[ppm1]

Your column needs to be DateTime (not just Date), or you need to wrap RangeStart and RangeEnd with Date.From in your M code.

Pat

[Vinod_G_245]

Hi Pat,

Thanks for Quick Reply,

Is it possible to share any reference for this.

we have only date column in data set

Thanks,

Vinod G

[ppm1 · Accepted solution]

Please see the Date Column section on this article.

How to use incremental refresh in Power BI - OdataLink

Pat

[Vinod_G_245]

Hi Pat,

     Thanks a lot, the document is explained well and I'm able  to do it.

Thanks,

Vinod G