Extract answers to additional questions from Microsoft Bookings appointment in Power BI Desktop

[MoeyersonsJ]

We are using Microsoft Bookings to set up coaching sessions with our Power BI community.

We would like to know from which department/team the people are that request coaching sessions, what problem they face,... To do so, we have added some extra questions to the service: 

We want to build a Power BI report on these booking info and used the Microsoft Exchange Online connector and the SMTP to connect. Most information seems to be available, but I cannot seem to find the answers to the additional questions.

Has anybody been through the same struggle and figured this out?

[Expiscornovus · Accepted solution]

Hi @MoeyersonsJ,

I have used the Graph API for this in the past.

The customQuestionAnswers property is listed within the bookingCustomerInformation resource:

https://learn.microsoft.com/en-us/graph/api/resources/bookingcustomerinformation?view=graph-rest-1.0

That bookingCustomerInformation (with the nested customQuestionAnswers) should also be returned in the Get bookingAppointment response, below is an example of the response:

https://learn.microsoft.com/en-us/graph/api/bookingappointment-get?view=graph-rest-1.0&tabs=http#res...