@Harris ,
Sounds like a great use of Power Automate within Power BI.
There’s actually a template for this type of action in Power Automate.
If you haven’t yet, I would also recommend checking out the excellent Power Automate Masterclass on the EDNA learning portal.
I hope this is helpful.
- Brian