Power Query Excel - can't connect to a pdf file data source RRS feed

  • Question

  • Dear all,

    With my Excel O365 i can import a pdf file. It is a new feaTure delivered in August and this will allow to process automatically my Bank pdf reports.
    Unfortunatly, i am not able to import all of them. For the last one, i am blocked at the step "please be patient, we establish a connection to file xxxx.pdf"

    I can't identify what is the blocage in the pdf file informations neither a difference between a pdf i can process and the other ones. All have the same certificate, all have the same encryption type. 

    Have you already had this type of behavior ? And what is the solution ?

    In advance thank you for your help,


    Saturday, September 12, 2020 10:31 AM


  • Hi Bruno. Sorry that you are having trouble. Would you be willing to send us the PDF file you are having trouble with? You can email it to danpere@microsoft.com .


    Tuesday, September 29, 2020 6:28 PM