Forum Discussion
subscription that writes to sharepoint location doesnt have option to replace existing file
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?
You could run a flow that deletes or moves the file a couple minutes before the subscription is scheduled.
3 Replies
- lbendlin
Super User
You could run a flow that deletes or moves the file a couple minutes before the subscription is scheduled.
SaiTejaTalasilaHi 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
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.
