Forum Discussion

dikshachoudhary's avatar
dikshachoudhary
Regular Visitor
2 years ago

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 calend...
Need Help
jennratten's avatar
jennratten
Icon for Super User rankSuper User
2 years ago

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],

 

  • dikshachoudhary's avatar
    dikshachoudhary
    Regular Visitor
    2 years ago

    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's avatar
      jennratten
      Icon for Super User rankSuper User
      2 years ago

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