Forum Discussion
Helper IAppending on Incrementally Refreshed Table
I have a large fact table that I incrementally refresh. I'm now being forced to append data at the end of that query from a table that doesnt incrementally refresh.
The issue I have is, when refreshing in desktop, the numbers are fine, but once in service, the appended data starts to duplicate.
I tried changing the append so it happens in a UNION in dax rather than powerquery, but im still seeing the same behaviour. Has anyone ever experienced this? And if so, please tell me you have a solution.
2 Replies
Hi joeparkinson ,
Based on the description, try to use a distinct function to ensure no duplicate data are being introduced.
What’s more, check incremental refresh policy on the fact table is correctly configured.
You can also view the following documents to learn more information.
Incremental refresh for semantic models in Power BI - Power BI | Microsoft Learn
DISTINCT (column) function (DAX) - DAX | Microsoft Learn
Troubleshoot incremental refresh and real-time data - Power BI | Microsoft Learn
Best Regards,
Wisdom Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Dave1mo1Helper III
Did you ever solve this issue? I'm running into it as well.
