Data Import & Export

Fix Excel Power Pivot SQL Server Import Object Reference Error

Maira MehtabMaira Mehtab Nov 14, 2026 868 views

Question details

Import SQL Server data into Excel when the Power Pivot import wizard returns an object reference error.

Product
Microsoft Excel Power Pivot
Device & OS
not provided
Scenario
A user connects Power Pivot to SQL Server and previews tables before completing an import.
Observed behavior
The connection and table previews work, but selecting Finish displays “Object reference not set to an instance of an object.”
Before you start

Have the SQL Server name, required credentials, and any SQL statement ready. Confirm that your Excel version offers Data > Get Data and supports the Data Model if you need to load data into Power Pivot.

Solution 1Recommended

Import SQL Server data through Excel's Get Data menu

Use Excel's data connection workflow instead of the Power Pivot import wizard to bypass the error.

1
Open the SQL Server connector

In Excel, select Data > Get Data > From Database > From SQL Server Database.

2
Enter connection details

Enter the server name and, if needed, the database name. To use a SQL query, expand Advanced options and enter the SQL statement, then select OK.

3
Authenticate and select data

If prompted, choose an authentication method, enter your credentials, and select Connect. In Navigator, select the table or query result you want to import.

4
Load the data

Select Load, or use the Load menu's Load To option if available. To use the data in Power Pivot, select Add this data to the Data Model in the import options, then confirm.

Import SQL Server data through Excel's Get Data menu
Results may vary: This alternate connection path worked with the same query in the reported case. The original Power Pivot import also worked afterward, but that result is not guaranteed.
Free Microsoft Office alternative

Work with Excel spreadsheets in WPS Office

WPS Office is a free, lightweight alternative with a familiar interface and Microsoft Office format compatibility, making it easy to move everyday spreadsheet work. It does not fix Excel's Power Pivot import error or replace every Power Pivot feature.

Open and edit Excel XLS and XLSX filesWork with spreadsheet data in a familiar interfaceMove everyday Office files with compatible document formatsUse a free, lightweight office suite
microsoft office alternative - wps office

Frequently Asked Questions

Why does Power Pivot show an error after the SQL Server preview works?

The connection and preview can succeed even if the Power Pivot import fails at Finish. The error alone does not identify the cause; try Excel's Data > Get Data > From Database > From SQL Server Database workflow as an alternative.

Can I use the same SQL query in Excel's import workflow?

Yes. In Data > Get Data > From Database > From SQL Server Database, expand Advanced options and enter the SQL statement before selecting OK.

How do I make the imported data available to Power Pivot?

In the connection's Load To options, select Add this data to the Data Model, then confirm. Your Excel version must support the Data Model.

Will WPS Office fix the Power Pivot import error?

No. The error occurs in Microsoft Excel's Power Pivot workflow. WPS Office can open and edit compatible Excel files, but it does not repair Power Pivot or replace every Power Pivot feature.