Forum Discussion
Microsoft Bookings - Reports
I agree - this would be great. The only way I've found so far to extract data from Bookings is using Excel:
Data>Get Data>From Online Services>From Microsoft Exchange Online> and then entering the email address associated with the booking page of the calendar. This will at least allow you to pull a list of bookings and show cancellations, etc
I have been working on this over the past week and the only way I have found to accomplish this is to pull that information from MSGraph. I'm not a programmer or powershell advanced user; I just learn by myself, so this was a big learning curve.
Anyways, there were quite a few steps but the biggest thing is authenticating to MSGraph. I spent close to 2 days trying to get this right. I can now pull up all booking appointments for a specific Booking email address.
You'll need to have rights to add App registrations in Azure AD as well as have Full Access rights to the Booking Account's mailbox (this is so your account can read/pull the calendar info). Then in Powershell, you'll need to install 2 modules:
Microsoft.Graph.Authentication
Microsoft.Graph.Bookings
Trying to get this to pull all appointments for all Booking accounts and export to excel. Not quite there yet though. If you want the specific instructions, just let me know. Since I just got this working yesterday, I still have to document it for work so I can supply it.
