Create a snapshot

Hi Ingo_BI ,

You can create a Power Automate (process) that triggers every Friday.
Specific process steps:
1.Connect data sources in desektop and create visual reports.
2.Then publish the Power BI report to the Power BI service.
3.Configure periodic refresh with the help of gateway to refresh the data at a specific frequency.
4.Email the successfully refreshed report to the concerned person.

For more details, you can  try below document:

Create a cloud flow in Power Automate - Power Automate | Microsoft Learn

Install an on-premises data gateway | Microsoft Learn

Data refresh in Power BI - Power BI | Microsoft Learn

Best Regards,
Adamk Kong

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.