Loading

Tableau Prep Builder / Desktop – "List Sites" is slow to load in the OneDrive & SharePoint Online connector on large tenants

Дата публикации: Aug 28, 2026
Описание

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.

  1. On the SharePoint Sites tab of the connector, locate the "Endpoint URL / Site URL" field.
  2. Paste the full URL of the specific SharePoint site you need, for example https://yourcompany.sharepoint.com/sites/SiteName.
  3. Click "Browse This Site."
  4. The connector opens that one site directly, without enumerating the rest of your tenant.

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.

  1. In a web browser, go to your SharePoint home (for example https://yourcompany.sharepoint.com).
  2. Use SharePoint's own search, or your "Following" and frequently visited sites, to find the site you need. Site discovery in the browser is quick and does not use the connector.
  3. Open the site, then copy its URL from the browser address bar.
  4. Trim the URL back to the site root before using it. After you click into a page, the address bar often includes extra path on the end (for example /SitePages/Home.aspx or /Lists/...). Use just the site root, for example https://yourcompany.sharepoint.com/sites/SiteName, rather than the full deep-linked page URL.
  5. Paste that URL into the "Endpoint URL / Site URL" field in Tableau and click "Browse This Site."

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:

  1. Allow the "List Sites" step the time it needs to finish loading rather than cancelling and retrying, as each retry restarts the full enumeration.
  2. If the environment sits behind a proxy or secure web gateway, or on virtual desktop infrastructure, your internal networking team can review the network path out to Microsoft to make sure added latency or packet loss on that route isn't compounding the delay. This won't change the underlying behavior but can help the environment side of the equation.
Номер статьи базы знаний

005393497

 
Загрузка
Salesforce Help | Article