Troubleshoot SharePoint Online Files Visible Only After Opening the Site
Question details
Users need to access SharePoint Online files directly without first visiting the site home page, including through automated SSIS processes.

- 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.
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.
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.
Open the recorded folder URL in a private or incognito browser window, sign in with an affected account, and note whether the files appear.
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.
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.
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.

Review SSIS Authentication and Direct File Access
Use this approach when an automated SSIS package also cannot access the SharePoint files.
Escalate the SharePoint Behavior to an Administrator or Microsoft Support
Escalate if direct access remains inconsistent after the session, permissions, and SSIS checks.
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.

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.




