Hi all, I am trying to automate the sharing of a Power BI report that draws its data from an SPO list to an external business partner.

As my organisation's rules are that we are not able to add external users to our PBI tenant I'm currently refreshing the .pbix file manually each week and then sending via Teams message to the external business contact who uploads it to their PBI tenant.

Im wondering if there's an opportunity to automate this in some way, ideally by a flow that could refresh the file and then send via email on a weekly schedule, is anyone aware of what could be done or has been in a similar situation and found a solution?