Forum Discussion
Connecting to Microsoft Exchange Online from Power Query Desktop outlook data is showing as empty
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.
3 Replies
- jennratten
Super User
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 [email protected] 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("[email protected]"), Calendar1 = Source{[Name="Calendar"]}[Data],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.
