When connecting to SharePoint through the OneDrive & SharePoint Online connector in Tableau Prep Builder or Tableau Desktop, choosing "List Sites" on the SharePoint Sites tab can take a very long time to populate, and the connection dialog may appear to hang while the list is being built.
This is most noticeable in large organizations where the signed-in account can access a high number of SharePoint sites (hundreds or thousands). The delay is not caused by a single slow site or a specific file, it scales with the total number of accessible sites.
This is a known limitation in how the connector discovers sites rather than a defect or a misconfiguration, so it cannot be resolved through connection settings or a version upgrade. The steps below provide a direct route that avoids the full site listing entirely.
Work through the following steps in order, stopping when the issue is resolved.
Step 1 — Connect directly to the site you need using "Browse This Site" (recommended)
The slowness comes from the connector loading every site your account can access before it displays anything. If you already know which site holds your data, you can skip that step completely and go straight to it. This loads in seconds regardless of how many sites your organization has.
Step 2 — Find the site URL in a browser first (if you don't know it)
If you or your users don't already know the exact site URL, you can look it up in a browser without triggering the slow listing, then use it with "Browse This Site" above.
Step 3 — If you specifically need the full list of sites
If your workflow requires browsing the complete list of sites via "List Sites," the enumeration will run to completion, it simply takes time on a large tenant. In that case:
005393497

We use three kinds of cookies on our websites: required, functional, and advertising. You can choose whether functional and advertising cookies apply. Click on the different cookie categories to find out more about each category and to change the default settings.
Privacy Statement
Required cookies are necessary for basic website functionality. Some examples include: session cookies needed to transmit the website, authentication cookies, and security cookies.
Functional cookies enhance functions, performance, and services on the website. Some examples include: cookies used to analyze site traffic, cookies used for market research, and cookies used to display advertising that is not directed to a particular individual.
Advertising cookies track activity across websites in order to understand a viewer’s interests, and direct them specific marketing. Some examples include: cookies used for remarketing, or interest-based advertising.