subscription that writes to sharepoint location doesnt have option to replace existing file

[mickeal_Davis]

I have a PowerBI Pagenated report subscription that writes the excel file to a sharepoint folder.

However, there iosnt an option to overwrite the file if it already exists.  Instead it adds a number to the filename so if i get a separate file each time the subscripotin runs.

I dont want to do this, I want to have onbe file that gets replaced when the subscription runs.

Is this supported?  Is there a work around so i dont end up with hundreds of files?

[mickeal_Davis]

Thats a bit of a shame.  Makes it more complicated than it really needs to be.
Ill give that a go.

The old on-premise portal subcriptions did overwrite if you wanted. Shame its been tken away.

[SaiTejaTalasila]

Hi @mickeal_Davis ,

What ever @lbendlin mentioned is the easiest way.To delete the file you can use power automate .

You can refer this -

https://domliu37.medium.com/power-automate-how-to-delete-sharepoint-files-and-folder-97999ca14301

Thanks,

Sai Teja 

[lbendlin · Accepted solution]

You could run a flow that deletes or moves the file a couple minutes before the subscription is scheduled.