Troubleshoot Power Query Not Working in Excel on Surface Laptop 7
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.

- 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.
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.
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.
Open Excel, navigate to 'File' > 'Account', click on 'Update Options', and select 'Update Now' to download the latest features and patches.
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.

Clear and Re-enter Data Source Permissions
Cached or corrupted credentials in Excel can prevent Power Query from connecting to your data source.
Gather Diagnostic Information for Microsoft Support
If standard troubleshooting fails, you may be facing an architecture or application bug that requires intervention from Microsoft Support.
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.

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.




