Connecting to Microsoft Exchange Online from Power Query Desktop outlook data is showing as empty

[dikshachoudhary]

hi, while getting data from outlook calendar using microsoft exchange in power bi desktop, facing issue that its coming as blank data only columns names is coming 

previously it was coming as calendar data in power bi.

what can be possible cause for this????

at this point while selecting calendar its showing black or null.

[jennratten]

Hello @dikshachoudhary - Please go to your table named Calendar and open the Advanced Editor. The first two lines in your script should look something like the script below.  In place of john.doe@abc.com you should see your email address.  If the table is not returning an error and you are seeing the columns but are not seeing any data in the columns, I would guess that the email address you have the source step is one that you have access to see (becuase an error is not being thrown) but it is not the one with your meetings.

let
    Source = Exchange.Contents("john.doe@abc.com"),
    Calendar1 = Source{[Name="Calendar"]}[Data],

[dikshachoudhary]

Hello @jennratten  thanks for your reply!!
i've tried this way and its exactly same as it should be but still data is empty.

please can you suggest other way to get data?

[jennratten]

Hi - You will need to enter your Microsoft Exchange account as opposed to a gmail account.