Answer · Customers & data

Does Microsoft Bookings have a reports dashboard?

Last updated 3 min readPart of Microsoft Bookings reporting and exports5 sources

The question people ask
“Does Microsoft Bookings have reports or a dashboard of all bookings?”

Asked in Microsoft Feedback Portal (opens in a new tab) and Microsoft Feedback Portal (opens in a new tab)

Short answer

Only a basic one. Each shared booking calendar has its own Home page and a TSV export of its appointments. As of September 2026, Microsoft Bookings has no dashboard that combines calendars, no charts over time and no reporting on where bookers came from. To see all bookings in one place, you export each calendar, or collect the data with Power Automate or the Graph API, and build the report yourself in Excel or Power BI.

What Bookings gives you#

  • The Home page, per calendar. Each shared booking calendar opens on a Home page, and the Bookings FAQ says its data "is retrieved whenever the Web app is loaded". It only shows the calendar you have open.
  • The TSV export, per calendar. From the Shared Bookings home page, Export downloads up to four months of appointments, one row per booking, with the service, staff, customer, custom answers and campaign tracking value. Only the Administrator role can download it. The steps, the full column list and how to open it without mangling it are in exporting Bookings to Excel.

That's the whole reporting surface. Everything else is something you build from the export.

What's missing#

  • A view across calendars. The FAQ says: "Each Bookings calendar is maintained independently. There's no consolidated view, other than the search drop-down after clicking the caret on the home page." The Feedback Portal idea "Bookings - Centralized Administration Needed" is the top-voted Bookings request, with 85 votes, and a January 2026 idea asks for one place to check reservation status across every shared booking page.
  • Trends and charts. No booking counts over time, utilisation by staff or no-show rates. You calculate those from the export; the Excel reporting guide has the pivots.
  • Marketing analytics. No page views, conversion rate or drop-off by step. The only source data is the RefID value in the Tracking data column, which users often find blank. Finding where visitors drop off shows the rough funnel you can build from GA4 and the export.
  • Usage across the organisation. Nothing counts how many booking pages exist or how much each is used. Admins piece that together with PowerShell and Graph; see tracking Bookings usage and adoption.
  • Personal pages. The export and Home page cover shared booking calendars only. For personal pages, see seeing all Bookings with me bookings.

Building a dashboard across calendars#

ApproachHow it worksTrade-offs
Manual exportsExport each calendar regularly and combine the files in Excel or Power BIManual. You need the Administrator role on every calendar.
Power AutomateA flow per calendar on "When a appointment is Created" (plus the Cancelled and Updated triggers) writes rows to a SharePoint list or Excel tableThe connector is in Preview, only Bookings admins can create the flows, and each booking mailbox allows five. Only new activity is captured.
Microsoft Graph APIA script reads appointments from each booking business on a scheduleNeeds a developer and admin-approved permissions. The FAQ points to the API "for more customized and specific purposes".

For the Power Automate route, the Power Automate CRM guide shows the flow pattern; swap the CRM step for a SharePoint or Excel row. Admins who can't open calendars made by other staff need to be added to each one first, since a tenant admin role doesn't open them.

Doing this with BookingsXP#

BookingsXP covers the marketing side, not the admin side. Its analytics show a funnel for bookings made through the widget on your site (saw the widget, picked a day, picked a time, started details, booked) by source and channel, plus the visits that found no open times. If you switch on Store bookings for your widgets, the bookings list shows widget bookings from every booking page you've embedded in one place. It doesn't see bookings made on the booking page Microsoft hosts or by staff in the Bookings calendar. BookingsXP is independent and not affiliated with or endorsed by Microsoft.

Questions people also ask

Sources

  1. Microsoft Learn: Reporting info (opens in a new tab) · learn.microsoft.com
  2. Microsoft Learn: Bookings faq (opens in a new tab) · learn.microsoft.com
  3. Microsoft Learn (opens in a new tab) · learn.microsoft.com
  4. Microsoft Feedback Portal (opens in a new tab) · feedbackportal.microsoft.com
  5. Microsoft Feedback Portal (opens in a new tab) · feedbackportal.microsoft.com