Connect to Shared mailbox o365 (cloud)

[Samurize24]

Hi Everybody,

We are trying to connect to a sharedmailbox that used to work with Power BI connector exchance.
Sinds some time now we can't acces the sharedmail box via Power BI. 

What happend:
1. Upgrade from Exchange 2010 naar Exchange 2016. But i don't this is the issue
2. Shared mailbox migrated to cloud ( )

Errors:
1.'Mailbox does not exist'
2. De versie van Exchange Server wordt niet ondersteund. Alleen Exchange Server 2007 SP1 of hoger wordt ondersteund.
Details.

I can connect to my own email, that hust works fine, its'just the shared mailbox.

Any tips will do.

Kind Regards,
Prashand

[Samurize24 · Accepted solution]

Solved: @GilbertQ  & @Anonymous 

Insted of using the connector i use the Power M fucntion instead. I don't know why, but it works 😁.
I would think the api's are not the same.
I used:

Exchange.Contents (optional mailboxAddress as nullable text) as table  

Cheers!

[jessical_7]

I tried this solution by using direct query and this api thing really helped me a lot! Most important thing is the data retrieval speed, which is at least 80% faster compared to using Microsoft Exchange Online Connector. Also I've seen the MS Exchange Online connector may not support scheduled refresh in reports, which could be a limitation. Reference: List of supported data sources 

I'm going to keep with this solution and see its performance goes over time.

Many thanks,

[Anonymous]

Hi @Samurize24,

What version of power bi desktop are you test? Have you tried to use other tools to connect to exchange at the current device? In addition, I'd like to suggest you to check the port and policy if any settings blocked the requests.

Please explain more about these to help us clarify your scenario:

How to Get Your Question Answered Quickly 

Regards,

Xiaoxin Sheng

[Samurize24]

Hi @Anonymous 
Power BI version: Versie: 2.84.981.0 64-bit (augustus 2020)

With the current connector i can just acces my personal mailbox just fine, it's just the one that is on a different 'platform' it seems.
outlook.0365.com just works fine,.

Kind Regards,

[GilbertQ]

Hi there

Could you make sure that the permissions are set correctly when logging into the Shared Mailbox?

Can you log into the shared mailbox with your credentials?

Are you then using the same credentials in your connection in Power BI?

[Samurize24]

Hi GilbertQ,

Could you make sure that the permissions are set correctly when logging into the Shared Mailbox?
Yes, they are correct.
Can you log into the shared mailbox with your credentials?
Yes ( with outlook everything works fine )
Are you then using the same credentials in your connection in Power BI?
Yes, i can connect to personal mailbox and a second sharemailbox as wel. Just the one does not connect using the same Exchange connector.