How to Fix Power Query PDF Import Stuck on Connecting in Excel
Question details
The user is unable to import data from a PDF file into Excel because Power Query freezes or hangs indefinitely on the connection screen.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Importing table data from a PDF document into an Excel workbook using the Get Data (Power Query) feature.
- Observed behavior
- The import process halts on the 'Connecting to file' dialog, preventing the PDF data from being loaded or transformed.
Ensure your PDF file is not password-protected or corrupted by opening it in a standard PDF reader first, and verify you have a stable local connection to the file.
Clear Power Query Cache and Update Privacy Settings
Clearing the global cache resolves background connection hangups, while adjusting privacy levels prevents strict security checks from blocking the PDF import.
Power Query stores temporary data to speed up connections. If this cache becomes corrupted, it can cause the importer to stall. Additionally, strict privacy settings might block Excel from finalizing the connection to external files like PDFs.
Open Excel, go to the 'Data' tab on the ribbon, click 'Get Data', and select 'Query Options'.
Under the 'Global' section on the left panel, select 'Data Load' and click the 'Clear Cache' button.
Navigate to the 'Privacy' section under Global and select 'Always ignore Privacy Level settings' for testing purposes.
Close the Query Options window, restart Excel, and attempt to import your PDF file again.

Use Microsoft Word as a Conversion Workaround
If Power Query continues to fail, converting the PDF to a Word document first can help extract the tables without relying on the Power Query engine.
Use WPS Office to Easily Convert PDFs to Excel Spreadsheets
Instead of struggling with Power Query import errors, you can use WPS Office's built-in PDF tool to directly extract tables and convert your PDF files into formatted Excel spreadsheets in just a few clicks.
- 1. Open the PDF: Launch WPS Office and click on the 'PDF' tab to open your target PDF file.
- 2. Select PDF to Excel: On the top toolbar, navigate to the 'Convert' tab and click on 'PDF to Excel'.
- 3. Convert the File: Choose the specific pages you want to extract and click the 'Convert' button.
- 4. Save as Spreadsheet: Save the newly generated spreadsheet, which is fully compatible with standard Excel formats.

Frequently Asked Questions
Why does Power Query freeze on 'Connecting to file' when importing PDFs?
This often happens due to corrupted cache data, overly strict data privacy settings in Excel, or complex vector graphics and massive tables within the PDF that overload the Power Query rendering engine.
Can I import a password-protected PDF into Power Query?
No, Power Query cannot natively bypass or prompt for PDF passwords during the initial connection phase. You must remove the password protection using a PDF editor before importing it into Excel.
How do I collect Power Query diagnostics if the problem persists?
Go to Data > Get Data > Query Options. Under the Global section, select Diagnostics, check 'Enable tracing', reproduce the 'Connecting to file' error, and then click 'Open traces folder' to find the diagnostic logs for support.




