Completely overwrite Dataverse table on each refresh

[Syndicate_Admin]

I have a SharepointList with ~25K rows.

To be able to show a summarised/pivot type view of this in the PowerApp I am creating the summary table using "group by"in Power Query which loads a table in Dataverse.

How can I, on each refresh, have the destination table/entity completely overridden with the new results of the refresh?

[v-yingjl]

Hi @Syndicate_Admin ,

Basically there is no 'overwrite' definition in Power Qurey when refreshing tables, after refreshing table in Power Query, the whole initial table would be refreshed to get the latest data from data source, not write the data in the table from Power Query to the data source.

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.