How to Fix Power Query SSL and Trust Errors with Access Database on OneDrive
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.

- 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.
Ensure you have your current OneDrive for Business login credentials ready and verify that you are running the latest version of Microsoft Office.
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.
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).
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.
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.
Navigate to 'File' > 'Account' in Excel and check for Office updates. Installing the latest updates can resolve underlying bugs related to SSL/TLS protocols.

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. Download and Install: Visit the official WPS website to download the free WPS Office installer and follow the quick setup instructions.
- 2. Open Your Spreadsheets: Launch WPS Spreadsheets and open your existing Excel files directly without worrying about format conversion.
- 3. Enjoy Seamless Editing: Experience lightweight and fast data management with an interface you already know and trust.

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.




