Answer · Customers & data

Does Microsoft Bookings have reports or a bookings dashboard?

Last updated 4 min read5 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 pull the data with the Graph API or Power Automate, then 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. The Bookings FAQ says its data "is retrieved whenever the Web app is loaded", and the export lives there too. It shows only the calendar you have open.

The TSV export (per calendar)#

From the Shared Bookings home page, select Export. On the Export recent data page, pick a date range and select Export. You get a tab-separated file you can open in Excel. Microsoft's reporting doc lists these columns:

  • Base fields: Date & Time, Customer Name, Customer Email, Customer Phone, Customer Address, Staff, Service, Location, Duration (minutes), Event Type
  • Added fields: Pricing Type, Price, Currency, Cc Attendees, Signed Up Attendees Count, Text Notifications Enabled, Custom Fields, Booking ID, Tracking data

Two points in the documentation are inconsistent:

  • Date range. The reporting doc says each file covers four months and that you can pick different four-month periods across a year. The FAQ says the file holds bookings from "the past 120 days".
  • Who can export. The FAQ says only staff with the Administrator role can download it.

For turning the export into pivot tables, see reporting on Bookings in Excel. The export steps themselves are in exporting Bookings to Excel.

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. A January 2026 idea asks for one place to check the reservation status of every shared booking page instead of running each page's report separately.
  • Trends and charts. Bookings has no booking counts over time, utilisation by staff or no-show rates. You calculate those from the export.
  • Marketing analytics. Bookings has no page views, no conversion rate and no report on which step people drop off at. The only source data is the RefID value in Tracking data, which users report is often blank. See RefID tracking not working.
  • Personal pages. The export and Home page cover shared booking calendars. 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 these flows, and Microsoft allows 5 flows per Bookings mailbox. Only new activity is captured.
Microsoft Graph APIA script or app reads appointments from each booking business on a scheduleNeeds a developer and admin-approved permissions. The FAQ points to the Bookings API for "more customized and specific purposes".

For the Power Automate route, the Bookings and Power Automate CRM guide shows the flow pattern. Admins who can't open calendars made by other staff should read admin access to all calendars first.

Doing this with BookingsXP#

BookingsXP helps with the marketing side of reporting, not the admin side. Its dashboard shows a funnel for bookings made through the widget on your site (saw the widget, picked a day, picked a time, started details, booked), broken down by source and channel. If you opt in to its data layer, it keeps a copy of each widget booking for CSV export and webhooks. It doesn't see bookings made on Microsoft's own page or by staff in the Bookings calendar. See analytics. 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