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.
Now is the time to dig in to the details of implementing incremental refresh. The details, which are not documented yet.
I ran into the below or a very similar error when I had composite queries combined with incremental refresh. E.g. you have a query, which uses another query to produce its result - one way or another. This may be a classical query append or merge. Or it may be just an innocent looking helper query for the query string template. This is typical in scenarios, where you use the various parameters to put together the SQL command dynamically.
The mashup engine checks for each query involved, and attempts to pass the range parameters to them. If the query takes them and does something with it, then there is no error. If the parameters are not used at all, then an error like yours is thrown.
PBI Desktop detects this requirement only on the final query: if the range parameters are not used, then it doesn't allow incremental refresh on that query at all.
Here is the catch:
The final query may have the range parameters used, but a subquery may not use it. This case remains unchecked in PBI Desktop, and it will allow incremental refresh to be configured. But later on it will throw an error in the Power BI Service at the first data refresh attempt.
So if this is your case, then make sure that you use the range start/end parameters in all the referenced queries. They don't necessarily need to be meaningful, but they must be used even if they don't do anything. Or eliminate the subqueries if you can.
This was only one theory for the error based on my experience. There may be another explanation too.
You were absolutely correct in your analysis of me having another query that was building my 2nd query which is where the parameters were filtering a "Modified" date.
I removed this query for testing purposes and put all the logic in one query with the parameters at the end filtering my "Modified" date. Unfortunately, I still get the same error in Power BI Service. All I've left in my data model is one query and the two parameters to test. I still get the same error. I'm at a loss of solutions now.
Just adding my name to the list. I can only cross my fingers that it's been fixed in the upcoming update. I am getting the same error, and although I am using merged queries I have followed the instructions provided in the documentation.
It would be good if the desktop was also able to utilise the incremental refresh and therefore throw up the error before publishing to the service.
You can always open a support case to let them dig out the details of the generic error, which you see. Digging in the dark left me out of clues for moving on in your case.
I agree that having the incremental refresh supported in the Power BI Desktop application would help a great deal. I would be surprised if it wouldn't be in their roadmap. In the meantime, maybe a new idea should be opened for that - if there isn't one already. If anybody finds it or creates it, please link it here.
