Fix Excel Power Pivot SQL Server Import Object Reference Error
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.”
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.
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.
In Excel, select Data > Get Data > From Database > From SQL Server Database.
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.
If prompted, choose an authentication method, enter your credentials, and select Connect. In Navigator, select the table or query result you want to import.
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.

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.

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.




