SOLVED

Microsoft Bookings - Reports

%3CLINGO-SUB%20id%3D%22lingo-sub-197177%22%20slang%3D%22en-US%22%3EMicrosoft%20Bookings%20-%20Reports%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-197177%22%20slang%3D%22en-US%22%3E%3CP%3EWould%20love%20to%20be%20able%20to%20report%20on%20Microsoft%20Bookings.%3CBR%20%2F%3EFuture%20pipe%20line%2C%20previous%20appointments%20%26nbsp%3Bect.%3C%2FP%3E%3CP%3Eis%20this%20in%20the%20roadmap%20at%20all%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-197177%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3Ebookings%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ECalendar%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOutlook%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-355277%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Bookings%20-%20Reports%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-355277%22%20slang%3D%22en-US%22%3E%3CP%3EThe%20export%20function%20seems%20to%20have%20been%20taken%20off.%20Any%20info%20how%20to%20get%20the%20data%20from%20the%20bookings%3F%20(I'm%20on%20a%20mac%20computer%20so%20no%20Get%20Data%20is%20working%20from%20Excel%20either.)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-299472%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Bookings%20-%20Reports%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-299472%22%20slang%3D%22en-US%22%3E%3CP%3EWorking%20for%20me%20as%20well%20now%2C%20but%20is%20only%20picking%20up%20bookings%20from%20mid-October%20onwards%20-%20so%20it%20can't%20be%20used%20for%20historical%20reporting%20but%20is%20still%20a%20big%20step%20forward.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-298691%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Bookings%20-%20Reports%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-298691%22%20slang%3D%22en-US%22%3E%3CP%3EMine%20is%20now%20working%2C%20Louise.%3C%2FP%3E%3CP%3ESave%20the%20TSV%20file%20to%20your%20desktop%2C%20open%20excel%2C%20then%20go%20File%20%26gt%3B%20Open.%20bottom%20right%20of%20this%20screen%20select%20all%20files%2C%20then%20find%20the%20TSV%20file.%3C%2FP%3E%3CP%3Epress%20next%20to%20the%20promps%20and%20you%20will%20have%20a%20simple%20view%20of%20your%20bookings!%3C%2FP%3E%3CP%3EModern%20technology!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-293332%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Bookings%20-%20Reports%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-293332%22%20slang%3D%22en-US%22%3E%3CP%3EThanks%2C%20just%20tried%20that%20but%20it%20still%20wont%20download%2C%20asks%20me%20to%20open%20with%20word%20etc%20but%20nothing%20shows%20%2F%20downloads%20-%20i'll%20keep%20trying%20at%20least%20with%20chrome%20it%20opens%20!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-293319%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Bookings%20-%20Reports%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-293319%22%20slang%3D%22en-US%22%3E%3CP%3ECould%20only%20get%20mine%20to%20open%20whilst%20using%20Google%20Chrome..%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-293317%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Bookings%20-%20Reports%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-293317%22%20slang%3D%22en-US%22%3E%3CP%3EThanks%20for%20the%20quick%20reply%20%3A)%3C%2Fimg%3E%20i%20did%20see%20the%20option%20for%20the%20CSV%20file%20but%20the%20link%20on%20my%20homepages%20doesn't%20seem%20to%20work.%20I'll%20check%20with%20our%20admin%20that%20we%20have%20the%20latest%20update%20as%20this%20would%20be%20a%20huge%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-293315%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Bookings%20-%20Reports%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-293315%22%20slang%3D%22en-US%22%3EYes%20this%20is%20now%20working%20for%20me%20with%20newly%20created%20calendars%2C%20but%20only%20seems%20to%20export%20data%20after%201st%20October%202018%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-293307%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Bookings%20-%20Reports%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-293307%22%20slang%3D%22en-US%22%3E%3CP%3EThere%20seems%20to%20have%20been%20an%20update%20over%20the%20past%20couple%20of%20days.%3C%2FP%3E%3CP%3Eyou%20can%20now%20export%20some%20data%20to%20TSV%20file%20-%20you%20can%20open%20this%20with%20Excel%2C%20mine%20however%20downloads%20a%201kb%20file%20without%20any%20data%20on..%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Esee%20link%20below%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-gb%2Farticle%2Freporting-information-for-microsoft-bookings-e150b415-d335-4818-93ac-acff4797a1b1%3Fui%3Den-US%26amp%3Brs%3Den-GB%26amp%3Bad%3DGB%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.office.com%2Fen-gb%2Farticle%2Freporting-information-for-microsoft-bookings-e150b415-d335-4818-93ac-acff4797a1b1%3Fui%3Den-US%26amp%3Brs%3Den-GB%26amp%3Bad%3DGB%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-293285%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Bookings%20-%20Reports%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-293285%22%20slang%3D%22en-US%22%3E%3CP%3Ei%20have%20the%20same%20result%20-%20reporting%20on%20bookings%20is%20essential%20-%20is%20there%20an%20alternative%20address%20to%20enter%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ethanks%20in%20advance%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-227784%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Bookings%20-%20Reports%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-227784%22%20slang%3D%22en-US%22%3EHas%20anyone%20got%20the%20Dash%20API%20setup%20for%20Bookings%3F%20This%20seems%20like%20it%20would%20be%20the%20way%20to%20go.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-199976%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Bookings%20-%20Reports%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-199976%22%20slang%3D%22en-US%22%3E%3CP%3Ehmmm%2C%20that's%20the%20address%20for%20my%20bookings%20page%2C%20no%20idea%20why%20it%20has%20an%20onmicrosoft%20domain%20%3A(%3C%2Fimg%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-199972%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Bookings%20-%20Reports%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-199972%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Luis%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBased%20on%20what%20you've%20said%20the%20mailbox%20name%20you%20would%20enter%20in%20Excel%20is%26nbsp%3Bsomename%40company.onmicrosoft.com%20%2C%20although%20I%20would%20have%20expected%20you%20to%20be%20using%20your%20own%20domain%20name%20(i.e.%20company.com)%20rather%20than%20company.onmicrosoft.com%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-199970%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Bookings%20-%20Reports%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-199970%22%20slang%3D%22en-US%22%3E%3CP%3EThanks%20Geoff%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20tried%20with%20your%20guide%20but%20I'm%20getting%20an%20error%20that%20the%20mailbox%20address%20isn't%20valid%2C%20my%20address%20is%20like%20this%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Foutlook.office365.com%2Fowa%2Fcalendar%2Fsomename%40company.onmicrosoft.com%2Fbookings%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Foutlook.office365.com%2Fowa%2Fcalendar%2Fsomename%40company.onmicrosoft.com%2Fbookings%2F%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20idea%20about%20this%20error%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-199903%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Bookings%20-%20Reports%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-199903%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Luis%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESee%20the%20attached%20file%20-%20hope%20that%20helps.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EGeoff%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-199669%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Bookings%20-%20Reports%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-199669%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Geoff%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20you%20explain%20me%20in%20deep%20how%20do%20you%20accomplish%20this%3F%3F%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20in%20advance%2C%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-199663%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Bookings%20-%20Reports%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-199663%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EI%20agree%26nbsp%3B%20x2%20-%20this%20would%20be%20great.%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-197240%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Bookings%20-%20Reports%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-197240%22%20slang%3D%22en-US%22%3E%3CP%3EI%20agree%20-%20this%20would%20be%20great.%20The%20only%20way%20I've%20found%20so%20far%20to%20extract%20data%20from%20Bookings%20is%20using%20Excel%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EData%26gt%3BGet%20Data%26gt%3BFrom%20Online%20Services%26gt%3BFrom%20Microsoft%20Exchange%20Online%26gt%3B%20and%20then%20entering%20the%20email%20address%20associated%20with%20the%20booking%20page%20of%20the%20calendar.%20This%20will%20at%20least%20allow%20you%20to%20pull%20a%20list%20of%20bookings%20and%20show%20cancellations%2C%20etc%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1170089%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Bookings%20-%20Reports%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1170089%22%20slang%3D%22en-US%22%3E%3CP%3EThanks!%20It%20works!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1403226%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Bookings%20-%20Reports%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1403226%22%20slang%3D%22en-US%22%3E%3CP%3EIs%20there%20a%20way%20to%20include%20more%20data%20like%20Customer%20notes%20or%20other%20Custom%20Fields%20that%20are%20created%20for%20the%20services%20to%20the%20report%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1403236%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Bookings%20-%20Reports%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1403236%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F672959%22%20target%3D%22_blank%22%3E%40Christine_Chong%3C%2FA%3E%26nbsp%3Bwe%20did%20not%20find%20a%20way%20to%20do%20that%2C%20but%20would%20love%20to%20be%20able%20to...%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1484454%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Bookings%20-%20Reports%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1484454%22%20slang%3D%22en-US%22%3EThank%20you!%20This%20is%20great!%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1524370%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Bookings%20-%20Reports%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1524370%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F672959%22%20target%3D%22_blank%22%3E%40Christine_Chong%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20been%20working%20on%20this%20over%20the%20past%20week%20and%20the%20only%20way%20I%20have%20found%20to%20accomplish%20this%20is%20to%20pull%20that%20information%20from%20MSGraph.%26nbsp%3B%20I'm%20not%20a%20programmer%20or%20powershell%20advanced%20user%3B%20I%20just%20learn%20by%20myself%2C%20so%20this%20was%20a%20big%20learning%20curve.%3C%2FP%3E%3CP%3EAnyways%2C%20there%20were%20quite%20a%20few%20steps%20but%20the%20biggest%20thing%20is%20authenticating%20to%20MSGraph.%26nbsp%3B%20I%20spent%20close%20to%202%20days%20trying%20to%20get%20this%20right.%26nbsp%3B%20I%20can%20now%20pull%20up%20all%20booking%20appointments%20for%20a%20specific%20Booking%20email%20address.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3EYou'll%20need%20to%20have%20rights%20to%20add%20App%20registrations%20in%20Azure%20AD%20as%20well%20as%20have%20Full%20Access%20rights%20to%20the%20Booking%20Account's%20mailbox%20(this%20is%20so%20your%20account%20can%20read%2Fpull%20the%20calendar%20info).%26nbsp%3B%20Then%20in%20Powershell%2C%20you'll%20need%20to%20install%202%20modules%3A%3C%2FP%3E%3CP%3EMicrosoft.Graph.Authentication%3C%2FP%3E%3CP%3EMicrosoft.Graph.Bookings%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETrying%20to%20get%20this%20to%20pull%20all%20appointments%20for%20all%20Booking%20accounts%20and%20export%20to%20excel.%26nbsp%3B%20Not%20quite%20there%20yet%20though.%26nbsp%3B%20If%20you%20want%20the%20specific%20instructions%2C%20just%20let%20me%20know.%26nbsp%3B%20Since%20I%20just%20got%20this%20working%20yesterday%2C%20I%20still%20have%20to%20document%20it%20for%20work%20so%20I%20can%20supply%20it.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1533742%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Bookings%20-%20Reports%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1533742%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F549064%22%20target%3D%22_blank%22%3E%40brphillips%3C%2FA%3E%26nbsp%3BThank%20you!%20I%20will%20have%20to%20play%20around%20with%20that%20some%20time.%20I%20am%20not%20too%20techy%20myself%20either!%20I%20will%20definitely%20reach%20out%20to%20you%20if%20I%20have%20any%20questions.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1573027%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Bookings%20-%20Reports%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1573027%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F549064%22%20target%3D%22_blank%22%3E%40brphillips%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHello%2C%20i%20have%20been%20looking%20for%20a%20solution%20to%20export%20the%20report%20to%20Sharepoint%20List.%26nbsp%3B%20Are%20you%20able%20to%20provide%20the%20instruction%20for%20me%20as%20well.%26nbsp%3B%20Thanks%20in%20advance.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1608182%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Bookings%20-%20Reports%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1608182%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F549064%22%20target%3D%22_blank%22%3E%40brphillips%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20you%20can%20send%20me%20the%20details%20that%20would%20be%20great%20too.%26nbsp%3B%20I%20have%20been%20asked%20to%20working%20on%20reporting%20for%20desk%20booking%20system%20created%20on%20MS%20Bookings..%3C%2FP%3E%3CP%3EThank%20you!%3C%2FP%3E%3CP%3EHeath%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1629576%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Bookings%20-%20Reports%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1629576%22%20slang%3D%22en-US%22%3E%3CP%3EI%20would%20also%20be%20interested%20in%20this.%20I%20was%20looking%20for%20a%20way%20to%20pull%20it%20all%20through%20into%20power%20BI...%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1629577%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Bookings%20-%20Reports%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1629577%22%20slang%3D%22en-US%22%3E%3CP%3EDoesnt%20this%20also%20show%20all%20other%20calendar%20entries%20not%20just%20Microsoft%20bookings%20entries%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1772165%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Bookings%20-%20Reports%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1772165%22%20slang%3D%22en-US%22%3EDid%20you%20find%20a%20solution%20yet%3F%20I%20am%20also%20looking%20to%20find%20how%20to%20extract%20these%20custom%20field%20notes.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1805533%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Bookings%20-%20Reports%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1805533%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F549064%22%20target%3D%22_blank%22%3E%40brphillips%3C%2FA%3E%26nbsp%3BIs%20your%20document%20still%20available%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1999864%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Bookings%20-%20Reports%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1999864%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F549064%22%20target%3D%22_blank%22%3E%40brphillips%3C%2FA%3E%26nbsp%3BAre%20you%20still%20able%20to%20provide%20documentation%20on%20this%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2032591%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Bookings%20-%20Reports%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2032591%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F549064%22%20target%3D%22_blank%22%3E%40brphillips%3C%2FA%3EI'd%20also%20love%20to%20see%20how%20you%20did%20this%20-%20I%20had%20a%20look%20at%20Graph%20but%20couldn't%20see%20how%20to%20access%20the%20custom%20fields.%26nbsp%3B%20I'm%20currently%20parsing%20the%20preview%20text%20in%20the%20confirmation%20emails%2C%20but%20this%20doesn't%20include%20the%20'additional%20information'%20from%20custom%20fields.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2084300%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Bookings%20-%20Reports%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2084300%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F549064%22%20target%3D%22_blank%22%3E%40brphillips%3C%2FA%3Edo%20you%20have%20your%20notes%20please%20need%20to%20do%20this%20tomorrow%20so%20would%20be%20very%20useful%20if%20you%20don't%20mind%20sharing.%26nbsp%3B%20Thank%20you%26nbsp%3B%20Catherine%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2108295%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Bookings%20-%20Reports%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2108295%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F549064%22%20target%3D%22_blank%22%3E%40brphillips%3C%2FA%3E%26nbsp%3BIf%20you%20can%20provide%20me%20with%20the%20reporting%20guide%20you%20were%20able%20to%20discover%20this%20may%20be%20helpful%20for%20what%20we%20are%20attempting%20to%20complete%20with%20Bookings%20as%20well.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2214344%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Bookings%20-%20Reports%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2214344%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20been%20using%20the%20bookings%20for%20about%201%20year%20now%2C%20and%20it%20still%20does%20not%20show%20anything%20being%20booked%20in%20the%20home%20section%20of%20bookings%2C%20even%20though%20we%20are%20getting%20loads%20of%20appointments.%20This%20being%20said%2C%20when%20I%20export%20to%20TSV%2C%20there%20is%20no%20data.%20Am%20I%20missing%20a%20setting%20or%20something%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2244065%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Bookings%20-%20Reports%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2244065%22%20slang%3D%22en-US%22%3E%3CP%3EI%20hope%20this%20is%20helpful%3C%2FP%3E%3CP%3EHow%20to%20export%20Bookings%20to%20an%20Excel%20sheet%3C%2FP%3E%3COL%3E%3CLI%3E%26nbsp%3B%3C%2FLI%3E%3C%2FOL%3E%3CTABLE%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%2255%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22SimonWindisch_0-1617094490937.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F268190i83FE0FCC3BF142E1%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22SimonWindisch_0-1617094490937.png%22%20alt%3D%22SimonWindisch_0-1617094490937.png%22%20%2F%3E%3C%2FSPAN%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CUL%3E%3CLI%3E%3CBR%20%2F%3EFind%20out%20the%20ID%20that%20Bookings%20uses%20for%20a%20calendar.%20In%20our%20case%20I%20defined%20the%20business%20name%20as%20%E2%80%9CSchool%20Primary%20School%E2%80%9D%20and%20so%20so%20the%20name%20it%20used%20was%3CBR%20%2F%3Eschool%40school.com%3C%2FLI%3E%3C%2FUL%3E%3COL%3E%3CLI%3EGo%20to%20the%20MS%20admin%20portal%20and%20change%20the%20password%20of%20that%20user%3C%2FLI%3E%3CLI%3ELog%20on%20to%20%3CA%20href%3D%22https%3A%2F%2Foutlook.office.com%2Fcalendar%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Foutlook.office.com%2Fcalendar%3C%2FA%3E%20with%20that%20user%3C%2FLI%3E%3CLI%3EGo%20to%20Settings%20%E2%80%93%20View%20all%20Outlook%20Settings%20-%26gt%3B%20Shared%20Calendars%20%E2%80%93%20Select%20the%20calendar%3C%2FLI%3E%3CLI%3ECheck%20that%20your%20own%20user%20can%20view%20the%20calendar%3C%2FLI%3E%3CLI%3EGo%20to%20the%20desktop%20Outlook%20app%3C%2FLI%3E%3CLI%3EGo%20to%20File%20-%26gt%3B%20Account%20Settings%20-%26gt%3B%20Account%20Settings%20-%26gt%3B%20Change%20-%26gt%3B%20More%20settings%20-%26gt%3B%20Advanced%20-%26gt%3B%20Add%20mailbox%20and%20enter%20your%20equivalent%20of%26nbsp%3B%3CBR%20%2F%3Eschool%40school.com%3C%2FLI%3E%3CLI%3EClick%20OK%20-%26gt%3B%20Next%20-%26gt%3B%20Done%20-%26gt%3B%20Close%3C%2FLI%3E%3CLI%3EClick%20File%20-%26gt%3B%20Open%20and%20Export%20%E2%80%93%20Import%2FExport%20-%26gt%3B%20Export%20to%20File%20-%26gt%3B%20Next%20-%26gt%3B%20Comma%20Separated%20Values%20-%26gt%3B%20Next%3C%2FLI%3E%3CLI%3EChoose%20the%20calendar%20that%20matches%20your%20business%20name%3C%2FLI%3E%3CLI%3ENext%20-%26gt%3B%20Choose%20a%20file%20name%20(I%20chose%20calendar_output.CSV%20-%26gt%3B%20Next%20-%26gt%3B%20Finish%3C%2FLI%3E%3CLI%3EChoose%20a%20date%20range%20%E2%80%93%20OK%3C%2FLI%3E%3CLI%3EOpen%20the%20exported%20CSV%20and%20open%20another%20new%20Excel%20sheet.%20The%20new%20excel%20sheet%20needs%20two%20rows%3A%3C%2FLI%3E%3CLI%3ERow%20one%20contains%20the%20following%20text%20fields%3COL%3E%3CLI%3EDate%3C%2FLI%3E%3CLI%3EStart%20Time%3C%2FLI%3E%3CLI%3EEnd%20Time%3C%2FLI%3E%3CLI%3ELength%3C%2FLI%3E%3CLI%3EStaff%20Member%3C%2FLI%3E%3CLI%3EStudent%20Email%3C%2FLI%3E%3CLI%3EJoin%20link%3C%2FLI%3E%3CLI%3EName_Pos%3C%2FLI%3E%3CLI%3EName-Len%3C%2FLI%3E%3CLI%3EEmail_Pos%3C%2FLI%3E%3CLI%3EEmail_len%3C%2FLI%3E%3CLI%3EBooking_pos%3C%2FLI%3E%3CLI%3EJoin_pos%3C%2FLI%3E%3CLI%3EJoin_len%3C%2FLI%3E%3CLI%3EIf_you_pos%3C%2FLI%3E%3C%2FOL%3E%3C%2FLI%3E%3C%2FOL%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3COL%3E%3CLI%3ERow%20two%20should%20contain%20the%20following%20formulas%3COL%3E%3CLI%3E%3D(calendar_output.CSV!B2)%3C%2FLI%3E%3CLI%3E%3D(calendar_output.CSV!C2)%3C%2FLI%3E%3CLI%3E%3D(calendar_output.CSV!E2)%3C%2FLI%3E%3CLI%3E%3DC2-B2%3C%2FLI%3E%3CLI%3E%3D(calendar_output.CSV!K2)%3C%2FLI%3E%3CLI%3E%3DMID(calendar_output.CSV!P2%2CL2%2CM2)%3C%2FLI%3E%3CLI%3E%3DMID(calendar_output.CSV!P2%2CN2%2CO2)%3C%2FLI%3E%3CLI%3E%3DMID(calendar_output.CSV!P2%2CQ2%2CR2)%3C%2FLI%3E%3CLI%3E(%E2%80%A6blank%20%E2%80%93%20for%20sanity)%3C%2FLI%3E%3CLI%3E%3DHYPERLINK((MID(calendar_output.CSV!P2%2CQ2%2CR2))%2C%22Join%20link%22)%3C%2FLI%3E%3CLI%3E%3D(calendar_output.CSV!A2)%3C%2FLI%3E%3CLI%3E%3DFIND(%22Name%3A%22%2Ccalendar_output.CSV!P2)%2B6%3C%2FLI%3E%3CLI%3E%3DN2-L2-6%3C%2FLI%3E%3CLI%3E%3DFIND(%22Email%3A%22%2Ccalendar_output.CSV!P2)%2B6%3C%2FLI%3E%3CLI%3E%3DP2-N2-6%3C%2FLI%3E%3CLI%3E%3DFIND(%22Booking%20Info%22%2Ccalendar_output.CSV!P2)%2B6%3C%2FLI%3E%3CLI%3E%3DFIND(%22Join%20Teams%20Meeting%22%2Ccalendar_output.CSV!P2)%2B18%3C%2FLI%3E%3CLI%3E%3DS2-Q2%3C%2FLI%3E%3CLI%3E%3DFIND(%22If%20you%20need%20a%20local%20number%2C%20get%20one%20here%22%2Ccalendar_output.CSV!P2)%3C%2FLI%3E%3C%2FOL%3E%3C%2FLI%3E%3CLI%3ECopy%2Fdrag%20row%20two%20down%20to%20match%20the%20number%20of%20rows%20in%20calendar_output.CSV%3C%2FLI%3E%3CLI%3EYou%20should%20see%20your%20data%20in%20an%20easy%20to%20read%20format.%3C%2FLI%3E%3C%2FOL%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2244542%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Bookings%20-%20Reports%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2244542%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1012347%22%20target%3D%22_blank%22%3E%40SimonWindisch%3C%2FA%3E%26nbsp%3BI%20found%20that%20the%20export%20in%20the%20bookings%20page%20does%20work%2C%20you%20just%20need%20to%20change%20your%20date%20range%20to%20when%20the%20bookings%20are%20expected%20to%20happen%2C%20not%20when%20the%20bookings%20take%20place.%20Once%20i%20changed%20the%20date%20to%20one%20day%20past%20our%20scheduled%20event%2C%20the%20TSV%20file%20was%20fully%20populated.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOne%20limitation%20i%20did%20notice%20is%20that%20the%20when%20it%20is%20imported%20into%20Excel%2C%20the%20person%20who%20received%20the%20booking%20is%20only%20their%20initials%2C%20not%20their%20full%20name.%20This%20caused%20confusion%20because%20we%20had%20multiple%20employees%20with%20the%20same%202%20initials.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20the%20Reply!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2252773%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Bookings%20-%20Reports%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2252773%22%20slang%3D%22en-US%22%3E%3CP%3Eyou%20can%20get%20the%20data%20in%20microsoft%20graph%20also.%26nbsp%3B%3C%2FP%3E%3CP%3Elogin%20at%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fdeveloper.microsoft.com%2Fen-us%2Fgraph%2Fgraph-explorer%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EGraph%20Explorer%20-%20Microsoft%20Graph%3C%2FA%3E%3C%2FP%3E%3CP%3Eassign%20the%20proper%20permission%20(check%20screenshot%2001%20and%2002)%3C%2FP%3E%3CP%3Erun%20the%20below%20query%20in%20GET%20%26gt%3B%20beta%20and%20copy%20the%20id%26nbsp%3B(check%20screenshot%2003)%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fgraph.microsoft.com%2Fbeta%2FbookingBusinesses%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fgraph.microsoft.com%2Fbeta%2FbookingBusinesses%2F%3C%2FA%3E%3C%2FP%3E%3CP%3Ereplace%20%3CA%20href%3D%22https%3A%2F%2Fgraph.microsoft.com%2Fbeta%2FbookingBusinesses%2FBookings%40fuuasttalent1.onmicrosoft.com%2Fappointments%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Etttttt%3C%2FA%3E%26nbsp%3Bwith%20id%20in%20the%20below%20query%26nbsp%3B%3C%2FP%3E%3CP%3ENow%20run%20the%20below%20query%20and%20you%20have%20all%20the%20data%20(check%20screenshot%2004)%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fgraph.microsoft.com%2Fbeta%2FbookingBusinesses%2FBookings%40fuuasttalent1.onmicrosoft.com%2Fappointments%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fgraph.microsoft.com%2Fbeta%2FbookingBusinesses%2Ftttttt%2Fappointments%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Efor%20more%20details%20check%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fkurthatlevik.com%2F2019%2F11%2F12%2Fmicrosoft-bookings-and-microsoft-graph%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3EMicrosoft%20Bookings%20and%20Microsoft%20Graph%20%7C%20Kurt%20Hatlevik%20%E2%80%93%20Dynamics%20365%20Blog%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2463771%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Bookings%20-%20Reports%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2463771%22%20slang%3D%22en-US%22%3EAmazing!%20Thank%20you!%20This%20has%20saved%20me%20so%20long%20as%20was%20about%20to%20give%20up%20and%20manually%20create%20a%20list!%3C%2FLINGO-BODY%3E
Deleted
Not applicable

Would love to be able to report on Microsoft Bookings.
Future pipe line, previous appointments  ect.

is this in the roadmap at all?

38 Replies
best response
Solution

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 agree  x2 - this would be great. 

Hi Geoff,

 

Can you explain me in deep how do you accomplish this???

 

Thanks in advance,

Hi Luis

 

See the attached file - hope that helps.

 

Geoff

Thanks Geoff,

 

I tried with your guide but I'm getting an error that the mailbox address isn't valid, my address is like this:

 

https://outlook.office365.com/owa/calendar/somename@company.onmicrosoft.com/bookings/

 

Any idea about this error?

Hi Luis

 

Based on what you've said the mailbox name you would enter in Excel is somename@company.onmicrosoft.com , although I would have expected you to be using your own domain name (i.e. company.com) rather than company.onmicrosoft.com

hmmm, that's the address for my bookings page, no idea why it has an onmicrosoft domain :(

Has anyone got the Dash API setup for Bookings? This seems like it would be the way to go.

i have the same result - reporting on bookings is essential - is there an alternative address to enter?

 

thanks in advance

There seems to have been an update over the past couple of days.

you can now export some data to TSV file - you can open this with Excel, mine however downloads a 1kb file without any data on..

 

see link below

https://support.office.com/en-gb/article/reporting-information-for-microsoft-bookings-e150b415-d335-...

Yes this is now working for me with newly created calendars, but only seems to export data after 1st October 2018

Thanks for the quick reply :) i did see the option for the CSV file but the link on my homepages doesn't seem to work. I'll check with our admin that we have the latest update as this would be a huge help.

 

Could only get mine to open whilst using Google Chrome..

Thanks, just tried that but it still wont download, asks me to open with word etc but nothing shows / downloads - i'll keep trying at least with chrome it opens !

Mine is now working, Louise.

Save the TSV file to your desktop, open excel, then go File > Open. bottom right of this screen select all files, then find the TSV file.

press next to the promps and you will have a simple view of your bookings!

Modern technology!

Working for me as well now, but is only picking up bookings from mid-October onwards - so it can't be used for historical reporting but is still a big step forward.

The export function seems to have been taken off. Any info how to get the data from the bookings? (I'm on a mac computer so no Get Data is working from Excel either.)

Thanks! It works!

Is there a way to include more data like Customer notes or other Custom Fields that are created for the services to the report?