Yes, this is very much possible and there are a couple of good approaches depending on what kind of reports you're working with.
Option 1: Power Automate + Power BI (Recommended)
This is the cleanest approach if your reports live in Power BI.
Trigger - Use a Recurrence trigger in Power Automate and set your schedule, daily, weekly, whatever fits.
Get your recipients - Use the Dataverse "List rows" action to pull users from Dynamics 365, filtering by role or team as needed.
Export the report - Use the Power BI "Export to File" action, pick your report and workspace, and choose the format like PDF or PPTX.
Send the email - Use "Apply to each" on your user list and send via Outlook connector with the exported file attached.
Note that the Export to File action needs a Power Automate Premium license.
Option 2: Power BI Subscriptions (Simplest)
If you just need a snapshot of a Power BI report emailed on a schedule, Power BI has a built-in Subscriptions feature. You can set it up directly in Power BI Service, no flow needed. Recipients get an email with a report snapshot at your chosen time and frequency.
Option 3: SSRS Reports in Dynamics 365
If you're using the native SSRS-based reports inside Dynamics 365 Sales, you can schedule them through SQL Server Reporting Services directly, though this requires server-level access and is less common in cloud deployments.
