Forum Discussion
Incremental Refresh Error
I get the same error message, and I am too trying to implement incremental reload (as per May release of Power BI).
Honestly, I believe this is a bug as the feature is still in preview.
This is a little frustrating. I've set up the parameters properly in Power BI Desktop, added a filter to a date/time field with the parameters, set up the table with incremental refresh, and published it into a premium workspace. After all of that, the paramters simply don't show up under the "parameters" section in the Power BI Service.
This then leads to the same error that the original poster is referring to. Does anyone know why aren't the parameters showing up properly in Power BI Service?
The parameters don't show up by design for now. This is a known and documented limitation.
My guess for the why is the handling of the RangeStart and RangeEnd parameters, which has to be automatic for the incremental refresh. Hence they had to disable their management on the UI, because that would lead to confusion. And instead of implementing it in a granular way - which may be underway for the generally available version -, they simply disabled parameters in general.
I really dislike this constraint, because from the end user's point of view it makes no sense, and it imposes a big limit on how one would deal with report development.
So if the parameters are not showing up in the Power BI Service and refreshing the dataset causes an error due to the parameters not being there, does this mean that incremental refresh isn't going to work currently? Is there a work around to this or are we stuck waiting for a more stable release by Microsoft before we can use incremental refresh?
The parameters have the values, which you were set in Power BI Desktop before you published the report to the Power BI Service. Certainly the refresh still works, otherwise releasing this feature wouldn't have made any sense at all.