Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

PowerBI outlook import issues

Hi all,

 

I am trying to get data on the attachments sent to a mailbox I manage. 

I have connected via Outlook Exchange Online and all data is pulling through correctly apart from attachments.

 

The issue is, data does come through and I can edit it, however when I try and expand the attachments column and refresh preview or 'apply changes' outside of Power Query, everything breaks down and I get the follow error message: 

 

"OLE DB or ODBC error: [DataSource.Error] The request failed. The remote server returned an error: (503) Server Unavailable.."

 

I have tried both ms exchange and ms exchange online yet still get the same error. 

 

Any thoughts?

 

Thank you in advance!

 

Need Help

9 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hello Anonymous ,

    can you please provide a screenshot and / or more explanation around the specific error? I would like to help since I have implemented the same but I am not sure I can fully understand :


    " when I try and expand the attachments column and refresh preview or 'apply changes' outside of Power Query"

     

    What do you mean "outside of power query"?

     

    Where do you need to store the attachments?

     

    DO you need to process them in Pquery as well?

     

    Can you try to do the same in PBI Desktop and see what happens?

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi Anonymous ,

       

      I can expand and amend all other data without any issues, however when I expand the below column to get the attachment names and file extensions, PowerBI does not like it.

       

       

      I get the following error every single time:

       

      "DataSource.Error: The request failed. The remote server returned an error: (503) Server Unavailable.
      Details:
      DataSourceKind=Exchange
      [email protected]"

       

      With regard to your questions:

      What do you mean "outside of power query"? - sorry this is just means on the view that you create the actual charts/graphs

       

      Where do you need to store the attachments? - I do not need to store the attachments anywhere, I just need to pull their names

       

      DO you need to process them in Pquery as well?  - just need to filter the extension type so only pdfs remain. 

       

      Can you try to do the same in PBI Desktop and see what happens? - I have been doing this in pbi desktop, have not tried an alternative