Hi Raechel,
I use a method similar to Lee's, but as we don't use MS Teams, I take a couple of different steps to make the data available to PowerBI.
Generate a scheduled report and send it to my email account.
Gmail filters and tags the email.
A Power Automate Flow recognises the tag, removes the report attachment, saves it in a OneDrive folder, and deletes the email.
PowerBI's 'scheduled refresh' picks up the new file and refreshes the report. (This step requires a data gateway to be running).
I hope that helps.