Forum Discussion

suebayes's avatar
suebayes
Icon for Resolver I rankResolver I
5 years ago
Solved

Incremental refresh failing due to parameter settings

I've configured my parameter settings to be date/time but when trying to add incremental refresh to the table am getting a fail on setting up parameters.  My parameters are below.  The only thing I can think is that I need to have AM PM at end but i can't get this to happen on two different instances of Power BI.

  • Thank you for replying, I have a RangeEnd parameter, it was the datatype that was causing the fail.  I had to set the column coming in from the sql server database as datetime specifically, even though it was datetime, then it worked.

2 Replies

  • You are missing the RangeEnd parameter. it is mandatory.

    • suebayes's avatar
      suebayes
      Icon for Resolver I rankResolver I

      Thank you for replying, I have a RangeEnd parameter, it was the datatype that was causing the fail.  I had to set the column coming in from the sql server database as datetime specifically, even though it was datetime, then it worked.