What are the pre-requisistes for Power Query to access Exchange mailbox data

[PoorMens_Bravo]

Hi All,

I am shocked to see that Power Query is able to import Exchange mailbox access data when the data is imported to Excel. Why am i shocked is that the mailbox is a shared mailbox and the user who is trying to import is not even having permissions on the Exchange mailbox. So, not sure how Power query is able to import the data when there is no permissions delegated to the logged in user

[PoorMens_Bravo]

Below are the steps i follow in Excel:

1. Open new excel sheet and click "Data" > "Get Data" > "From Other Sources" > "From Microsoft Exchange"                  
2. A window will pop up that says Microsoft Exchange. Type in under Mailbox address the email for the inbox you want to pull a report for and click OK: 
3. A screen will pop up saying to enter a password. Disregard this. You will need to click “Microsoft Exchange” under Exchange account. Click “sign in.” and connect.” 
4. You will need to click “Microsoft Exchange” under Exchange account. Click “sign in.” A window will pop up to sign in to your account. Pick your personal Microsoft account to sign in.  It will say you are signed in. Then click “connect”.
5. In Navigator click on "Mail" and click "Transform Data" 

The fact is that, i myself am able to access mailbox data of which i do not have access to.

[Omid_Motamedise]

Are you sure you can see tge data other than those you have access?

[Anonymous]

I use the Exchange connector daily, and no one without permission to that mailbox has ever been able to refresh it. Are you saying that a person without permissions is able to refresh that query?

--Nate

[PoorMens_Bravo]

Below are the steps followed: 1. Open Excel, Get Data, From Other Sources, From Microsoft Exchange, add UPN of the mailbox, switch to Microsoft account for Authentication, Sign in, i see the data is loaded. The fact is, i myself am able to access a shared mailbox, that i do not have access to.