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 cale...
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)

     

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?

      • P-2019's avatar
        P-2019
        Frequent Visitor
        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)