Forum Discussion

P-2019's avatar
P-2019
Frequent Visitor
7 years ago
Solved

Connect to Shared Calendars

Hi,

 

I want to connect with several shared calendars in PowerBI.

Is that possible?

I'm able to connect with my own Calendar, but not with the shared Calendars.

When I connect to the shared calendar in Outlook I can see the data, but I can't connect to it with Power BI.

 

Under Get Data I opted for "Microsoft Exchange Online". In the field that follows I entered the mailaddress of the shared mailbox. When I select "calendar" I receive the following message:

 

 

Is there a way to connect with a shared Calendar?

 

Thanks!

 

 

 

Show and Tell
  • P-2019's avatar
    P-2019
    7 years ago

    Hi,

     

    I have it working now.

     

    This how it worked for me (but i don't know if there is also an alternative solution).

     

    - Get data-> Exchange online-> entered the mailaddress from the colleague who shared his agenda with me

    - select Microsoft account, entered my credentials

    - Select calendar 

    At this point I received the following error message: 

    DataSource.Error: ErrorItemNotFound: The specified object was not found in the store., The process failed to get the correct properties.
Details:
DataSourceKind=Exchange
DataSourcePath=[mail address from the colleague]
Details=

    to solve this I let my colleague set the right ons his mailbox to show the folder.

     

    (Dutch Screenshot)

     

20 Replies

  • v-juanli-msft's avatar
    v-juanli-msft
    Community Support
    7 years ago

    Hi P-2019 

    What "mailaddress of the shared mailbox" do you enter? (hide the privacy info)

     

    I have success test before:

    My mailaddress of Outlook is ***@microsoft.com, this is also the account used for my Power BI.

    Get data-> Exchange online->enter ***@microsoft.com,

    select Microsoft account, enter the account "***@microsoft.com" and its password,

    select a shared mailbox(Meeting Requests on my side)

     

    Please check if there are any security and accessibility problems on Exchange side, there is a similar thread for your reference: Connection with shared rooms in exchange

    If you connect to shared mailbox, please make sure that it is not a on-premise mailbox, but a O365 online mailbox.

     

    Best Regards
    Maggie

     

    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • P-2019's avatar
      P-2019
      Frequent Visitor
      7 years ago

      Hi v-juanli-msft ,

       

      Thanks for your reply.

       

      I've tried it with the same steps you described, but can't see the shared calendars.

       

      1. Get data-> Exchange online->entered my mailaddress

      2. select Microsoft account, -> entered my credentials

       

      next i will see the following:

      Under Calendaar are only my appointments and under "Meeting request" is see only my meetingsrequests.

       

      I also tried it with a seperate impersonate account that have the full rights on every calendar. 

      We are using only O365 mailboxes.

      • P-2019's avatar
        P-2019
        Frequent Visitor
        7 years ago

        We are using only O365 mailboxes.

        .....at least that's what I think. How can I check this?

  • danihello's avatar
    danihello
    New Member
    6 years ago

    Dosent work for me either it is really frustrating.

     

    If anyone solved it I would like to hear about it as well.

  • darmstrong's avatar
    darmstrong
    Frequent Visitor
    5 years ago

    Hi, is there any update on this? I am experiencing the same issues and am keen to get this working.

    Thanks

  • LucaSilva1998's avatar
    LucaSilva1998
    New Member
    5 years ago

    Olá,

     

    Pessoal segui os mesmos passos mas esbarrei nos mesmos erros. Vocês conhecem um outro caminho para solucionar este erro?

     

    Atenciosamente,