Power Query Problems

How to Fix Power Query PDF Import Stuck on Connecting in Excel

Rana GarciaRana Garcia Oct 23, 2026 870 views

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.

How to Fix Power Query PDF Import Stuck on Connecting in Excel
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.
Before you start

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.

Solution 1Recommended

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.

1
Open Query Options

Open Excel, go to the 'Data' tab on the ribbon, click 'Get Data', and select 'Query Options'.

2
Clear Data Load Cache

Under the 'Global' section on the left panel, select 'Data Load' and click the 'Clear Cache' button.

3
Adjust Privacy Settings

Navigate to the 'Privacy' section under Global and select 'Always ignore Privacy Level settings' for testing purposes.

4
Restart and Retry

Close the Query Options window, restart Excel, and attempt to import your PDF file again.

Clear Power Query Cache and Update Privacy Settings
Security Note: Remember to revert your privacy settings to their original state after successfully importing the data, especially if you frequently connect to sensitive web data sources.

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. 1. Open the PDF: Launch WPS Office and click on the 'PDF' tab to open your target PDF file.
  2. 2. Select PDF to Excel: On the top toolbar, navigate to the 'Convert' tab and click on 'PDF to Excel'.
  3. 3. Convert the File: Choose the specific pages you want to extract and click the 'Convert' button.
  4. 4. Save as Spreadsheet: Save the newly generated spreadsheet, which is fully compatible with standard Excel formats.
Direct PDF to Excel conversion with high accuracyMaintains original table layouts and formattingFully compatible with Microsoft Excel (.xlsx) formatsLightweight, fast, and completely free to download
microsoft office alternative - wps office

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.