Forum Discussion
Helper IIDataflow Incremental Refresh failing to save
Hi AmazingRandom,
Thank you collinq for your response to the query.
The error MashupDocumentContainsDuplicateQueryName usually occurs when the dataflow mashup contains duplicate query or parameter names, even if the UI appears to show only one parameter.
For incremental refresh in Dataflows, the system specifically expects two parameters named RangeStart and RangeEnd, both with the DateTime data type. If parameters were previously created, renamed (for example to pRangeStart and pRangeEnd), or left over from earlier incremental refresh attempts, the service may still try to generate RangeStart and RangeEnd again during the save process. This can result in a duplicate name conflict.
To resolve the issue, please check the Power Query editor and ensure that:
- Only one RangeStart and one RangeEnd parameter exist
- Both parameters are of DateTime type
- There are no additional parameters or queries with similar or duplicate names created from earlier configurations
After confirming this, remove any extra or renamed parameters, keep only RangeStart and RangeEnd, and then configure incremental refresh again before saving the dataflow.
Thank you.
Super UserHi AmazingRandom ,
Based solely on the error message, the mashup contains' two or more queries with the exact same name. Maybe you have a duplicated query? Or maybe when you did this before it set some RangeStart and RangeEnd paramater and now you have two of them? I would look for duplicate parameters as well as duplicate queries.
Helper III do not have duplicated, as it shows on the options in the first screenshot, only one DateTime, after that, it looks like the incremental refresh auto generates, but how do I circumvent this? I tried renaming my parameters to pRangeStart and pRangeEnd but it failsto save the dataflow