Forum Discussion
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
- lbendlin
Super User
You are missing the RangeEnd parameter. it is mandatory.
- suebayes
Resolver 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.