Power Query Problems

Troubleshoot Power Query Not Working in Excel on Surface Laptop 7

Steven ParkerSteven Parker Nov 10, 2026 869 views

Question details

Users experience failures when attempting to run Power Query in Excel on a Surface Laptop 7, despite the same queries functioning correctly in Power BI.

How to Troubleshoot Power Query in Excel on Surface Laptop 7
Product
Microsoft Excel
Device & OS
Surface Laptop 7
Scenario
Attempting to connect to data sources or run Power Query transformations in Excel on a Surface Laptop 7.
Observed behavior
Power Query fails to execute or connect to data in Excel due to potential platform support, software build limitations, missing connectors, or permission conflicts.
Before you start

Ensure your Surface Laptop 7 is connected to a stable network and that you have your Microsoft 365 account and data source credentials ready before making changes to data settings.

Solution 1Recommended

Update Excel and Verify Connector Compatibility

Ensuring you are running the latest supported Microsoft 365 build can resolve compatibility issues with built-in data connectors.

Power Query features and connector availability frequently change between Microsoft 365 updates. Updating your software ensures you have the latest engine fixes for your specific device architecture.

1
Update Microsoft Excel

Open Excel, navigate to 'File' > 'Account', click on 'Update Options', and select 'Update Now' to download the latest features and patches.

2
Test a built-in connector

Go to the 'Data' tab, click 'Get Data', and try importing from a simple local source (like 'From Text/CSV'). If this succeeds, the core Power Query engine is working, and the issue lies with a specific external connector.

Update Excel and Verify Connector Compatibility
Microsoft 365 Subscription Required: Some advanced Power Query connectors are only available in the Microsoft 365 subscription versions of Excel, not in perpetual standalone versions.
Free Microsoft Office alternative

Looking for a Lightweight and Reliable Excel Alternative?

If you frequently encounter heavy resource usage, architecture compatibility issues, or complex troubleshooting steps with Microsoft Excel on your device, consider switching to WPS Office. It provides a robust, lightweight, and free alternative for your daily spreadsheet and data analysis needs.

Fully compatible with Microsoft Excel formats (.xlsx, .xls, .csv).Lightweight architecture ensures fast startup and smooth performance on modern laptops.Includes powerful data analysis features, advanced charting, and pivot tables for free.Familiar tabbed interface allows you to transition seamlessly without a learning curve.
microsoft office alternative - wps office

Frequently Asked Questions

Why does Power Query work in Power BI but fail in Excel?

Power BI often receives Power Query engine updates and new data connectors before Excel. Additionally, Excel relies on your specific Office installation architecture and Microsoft 365 licensing, which might restrict access to certain premium connectors available in Power BI.

Can the Surface Laptop 7 architecture cause Power Query errors?

Yes. Depending on the processor in your Surface Laptop 7, certain older 32-bit or third-party ODBC/OLEDB drivers required by specific Power Query connectors may lack native compatibility and trigger errors during data retrieval.

How do I check if my Excel version supports my desired data connector?

You can verify your version by going to File > Account. Microsoft routinely updates its official support documentation online to list which specific Microsoft 365 builds and license tiers include support for advanced connectors like Salesforce, Azure, or direct SQL databases.

What should I do if clearing data source permissions doesn't fix the login error?

If clearing permissions does not resolve the issue, try signing out of your Microsoft 365 account entirely from within Excel (File > Account > Sign Out), restarting your laptop, and signing back in to refresh all active authentication tokens.