Setting up scheduled reports Coming soon
What the one-time setup creates in your Azure
Coming soon. This tool is built and shows on its menu, but it does not open in a released build yet. This page describes it as it will ship.
Scheduled reports run in a small Azure Functions app in your own subscription. Setup creates it in one sign-in and checks every permission it needs before it creates anything. Azure bills the usage to your subscription; for a handful of weekly reports on a small or medium tenant that is typically within Azure's monthly free grant.
Reads only. Nothing in SharePoint is changed.
What does it tell you?
- What it creates: a reports app, its own storage account (separate from Archive's), and a managed identity for the app. A managed identity has no password or certificate to expire.
- What the identity may do: read the directory, groups, Teams and usage reports the scheduled reports need, by name, listed before you create anything. It may not change them.
- Who it may send as: only the one mailbox you choose at setup. Setup proves it by sending you a test message and by checking that sending as a different mailbox is refused.
- Where large workbooks go: a ShareMaster Reports library on the one site you choose, which the identity may write to and nothing else.
- How long workbooks are kept: 30 days by default, 1 to 365. Run records are kept for a year.
- Removing it: Remove setup on the same page removes the app, its storage, the mailbox scope, the library and the identity's permissions, and says plainly anything it could not remove.
How it runs
- Open Reports › Scheduled reports. Choose the account to sign in with. The one sign-in asks for everything setup and the schedules need, so nothing asks again later.
- Azure. Choose the subscription, then a resource group and region, or let setup create a separate group.
- Sender and boundary test. Choose the mailbox reports are sent from, and a different mailbox that the reports app must be refused.
- Recipients and delivery site. Choose the mail-enabled group that may open linked workbooks, and the site for the ShareMaster Reports library.
- Set up / verify. Every stage is shown as it runs, with Stop. Running it again on a finished setup checks it rather than building anything twice.
Read next
- Scheduled reports: Scheduling a report once setup is done.