SharePoint Document Issues

Troubleshoot SharePoint Online Files Visible Only After Opening the Site

Adam DavisAdam Davis Nov 14, 2026 868 views

Question details

Users need to access SharePoint Online files directly without first visiting the site home page, including through automated SSIS processes.

Troubleshoot SharePoint Online Files Visible Only After Opening the Site
Product
SharePoint Online and SQL Server Integration Services (SSIS)
Device & OS
not provided
Scenario
Users and automated processes open a folder in a SharePoint site's Documents library directly.
Observed behavior
Files do not appear when the folder is opened directly, but they appear after a user first visits the site's home page. SSIS processes are also affected.
Before you start

Record the affected site home page, document library, folder, and file URLs, along with the accounts used by browsers and SSIS. Note the time of each test and any error messages or correlation IDs.

Solution 1Recommended

Compare Direct Access Across Browser Sessions and Check Permissions

Use these checks to narrow down whether the behavior is related to the link, authentication session, or access permissions.

The original discussion did not establish a confirmed resolution. These steps are diagnostic and may help an administrator identify the cause.

1
Test the direct folder link

Open the recorded folder URL in a private or incognito browser window, sign in with an affected account, and note whether the files appear.

2
Compare with the site home page

In the same browser session, open the affected site's home page, then return to the same folder URL. Record any change and repeat the comparison in another browser.

3
Check the library and folder

From the site home page, open Documents and navigate to the affected folder. Compare the resulting URL with the direct link and check whether the same files appear.

4
Review access permissions

Ask a SharePoint administrator to open the site's Settings > Site permissions and check the affected account's access. Also review permissions and inheritance on the library, folder, and affected files.

Compare Direct Access Across Browser Sessions and Check Permissions
Capture useful evidence: Save the test times, URLs, account names, and any errors or correlation IDs for the administrator. Do not share passwords or authentication tokens.
Free Microsoft Office alternative

Work With Office Documents Using WPS Office

WPS Office is a free, lightweight alternative with a familiar interface for working with Office documents. Open accessible copies of your files to support a smooth transition between office suites; WPS Office does not fix SharePoint access or SSIS authentication issues.

Open and edit accessible document copies while SharePoint access is investigatedCompatible with Microsoft Office formats including DOCX, XLSX, and PPTXUse a familiar interface for documents, spreadsheets, and presentationsGet a free, lightweight office suite
microsoft office alternative - wps office

Frequently Asked Questions

Why do SharePoint files appear after I open the site home page?

The cause was not confirmed in the original discussion. Compare the direct folder link before and after visiting the site home page in the same browser session, then ask an administrator to investigate the session, link, and permissions.

How can I check whether the direct folder link is correct?

Open the site home page, select Documents, and navigate to the folder. Compare the resulting URL and file list with those from the direct link.

Could SSIS rely on a browser session to access the files?

An automated package should use a supported authentication method and a direct file access endpoint rather than depend on an interactive browser visit. Review the SSIS connection manager and task configuration with your administrator.

What should I send to Microsoft Support?

Provide the affected site and folder URLs, test times, accounts used, browser and SSIS results, and any error messages, HTTP statuses, or correlation IDs. An administrator can contact support through the Microsoft 365 admin center.