Power Query Problems

How to Fix Power Query SSL and Trust Errors with Access Database on OneDrive

Phi Hung VoPhi Hung Vo Nov 2, 2026 870 views

Question details

Users need to resolve an issue where Power Query loses access to an Access database hosted on OneDrive, resulting in an SSL/TLS trust relationship error.

How to Fix Power Query SSL and Trust Errors with Access Database on OneDrive
Product
Excel Power Query
Device & OS
not provided
Scenario
Refreshing or establishing a Power Query connection to an Access database located on a OneDrive for Business server after recent system changes.
Observed behavior
The connection fails, displaying an error message about an SSL/TLS trust relationship or lost access, preventing the user from retrieving data.
Before you start

Ensure you have your current OneDrive for Business login credentials ready and verify that you are running the latest version of Microsoft Office.

Solution 1Recommended

Clear Data Source Permissions and Reconnect

Resetting the cached data source permissions forces Power Query to establish a fresh, newly authenticated connection to your OneDrive database.

Power Query connection errors often occur when cached credentials expire, permissions are changed, or the underlying OneDrive URL is updated. Clearing the outdated data source permissions is the most effective way to resolve these SSL/TLS trust issues.

1
Open Data Source Settings

Launch Excel, navigate to the 'Data' tab on the top ribbon, and click on 'Data Source Settings' (this is typically located under the 'Get Data' dropdown menu).

2
Clear Existing Permissions

In the Data Source Settings dialog box, locate and select the specific OneDrive connection that is failing. Click the 'Clear Permissions' button and confirm your choice.

3
Reconnect to OneDrive

Open Power Query and attempt to connect to the correct OneDrive for Business URL again. When prompted, enter your current Microsoft account credentials to establish a new trusted connection.

4
Verify Office Version

Navigate to 'File' > 'Account' in Excel and check for Office updates. Installing the latest updates can resolve underlying bugs related to SSL/TLS protocols.

Clear Data Source Permissions and Reconnect
URL Verification: Double-check that the OneDrive URL you are connecting to is current. SharePoint or OneDrive migrations frequently alter the base URL, which will cause previous connections to fail.
Free Microsoft Office alternative

Try WPS Office for Seamless and Lightweight Data Management

If complex data connection errors and heavy software loads in Microsoft Office disrupt your workflow, consider switching to WPS Office. It is a highly compatible, lightweight, and free alternative that supports standard Excel formats while providing a clean, user-friendly interface.

  1. 1. Download and Install: Visit the official WPS website to download the free WPS Office installer and follow the quick setup instructions.
  2. 2. Open Your Spreadsheets: Launch WPS Spreadsheets and open your existing Excel files directly without worrying about format conversion.
  3. 3. Enjoy Seamless Editing: Experience lightweight and fast data management with an interface you already know and trust.
Fully compatible with Microsoft Excel formats (.xlsx, .xls, .csv).Lightweight installation with fast loading times and smooth performance.Free to use with a familiar interface, requiring no learning curve.Built-in cloud features for easy file synchronization, backup, and management.
microsoft office alternative - wps office

Frequently Asked Questions

Why does Power Query show an SSL/TLS trust relationship error?

This usually happens when the cached credentials or security certificates used to connect to OneDrive become outdated or corrupted. It frequently occurs after a password reset, a change in folder permissions, or a server update.

How do I find the correct URL for my OneDrive for Business site?

You can log into your OneDrive account via a web browser, navigate to the specific folder containing your Access database, and copy the URL directly from the browser's address bar.

Will clearing data source permissions delete my Excel data?

No. Clearing permissions in Excel only removes the saved login credentials and connection settings for that specific source. Your actual data in both the Excel spreadsheet and the Access database remains completely safe and untouched.

Why is Power Query suddenly failing to connect on a new computer?

When you move to a new computer, Excel does not automatically transfer your cached local credentials or trusted connection settings. You must re-authenticate the data source on the new device to establish a trusted connection.