# OneDrive and Sharepoint Connector - New in Tableau 2022.2

> This is content from just-tim, the data-and-analytics channel by Tim Ngwena (formerly 'Tableau Tim'). Tim has 12+ years of hands-on BI experience and covers Tableau most of all, plus Power BI, Looker, Hex, SQL and data modelling, the analytics industry, and the craft of doing the job — always tool-agnostic and honest about the trade-offs.

- **Author:** Tim Ngwena (just-tim, https://just-tim.com/about)
- **Published:** 2022-07-11
- **Format:** Video · 8 min watch · transcript available
- **Topics:** Data prep, Tool strategy
- **Tools:** Tableau (connectors, prep)
- **Canonical:** https://just-tim.com/posts/onedrive-and-sharepoint-connector-new-in-tableau-2022-2
- **Watch:** https://www.youtube.com/watch?v=scM__RFb100

I walk through the new combined OneDrive and SharePoint connector introduced in Tableau 2022.2, showing how it replaces the older standalone connectors and lets you pull files from both OneDrive and SharePoint document libraries through a single login. I also flag a CSV header issue and explain how to set up a free Microsoft 365 developer account to test it yourself.

## Key takeaways

- The 2022.2 OneDrive and SharePoint online connector combines both sources into one, including access to shared OneDrive files and SharePoint sites and document libraries.
- The older SharePoint Lists connector requires downloading a driver and can't reach document library files, so the new combined connector is the smoother option.
- CSV files connected this way don't let you promote the first row to column headers in the desktop interface, so you either rename fields manually or do data prep in Tableau Prep first.
- Excel files carry their own header information, so they import cleanly without the CSV workaround.
- Each file is treated as a separate connection and re-authenticates against Microsoft, and the same connector behaves identically in Tableau Prep.
- You can get a free 90-day Microsoft 365 developer account to spin up SharePoint sites and test the connector without paying.

## Chapters

- 0:00 The new combined connector
- 0:51 Comparing old OneDrive and SharePoint connectors
- 2:05 Browsing SharePoint sites and the CSV header issue
- 4:18 Connecting to an Excel file
- 5:19 Using the connector in Tableau Prep
- 6:39 Setting up a free Microsoft 365 developer account

Watch the full video, read the transcript and use chapter deep-links on the page: https://just-tim.com/posts/onedrive-and-sharepoint-connector-new-in-tableau-2022-2

---
just-tim — Data and analytics, with a point of view. · https://www.youtube.com/channel/UC7HYxRWmaNlJux-X7rNLZyw · https://twitter.com/TableauTim · https://www.linkedin.com/in/timngwena