Have you tried the built in SharePoint Lists connector in Tableau Desktop? Or did you receive errors when using it?
thanks for responding and prompting me to provide my solution. And yes, I used the SharePoint list connector and couldn’t get it to work initially. However, I wasn’t aware that this connector actually uses an OBDC driver under the hood. I thought these things were retired sometime in the last century.
Anyway the solution was to re-configure the driver with the new site collection and security details. Once that was in place the configuration of the SharePoint connector layer actually worked
I still believe there must be another way because this approach would mean that you would only be able to connect to one SharePoint instance at the time. This doesn’t matter in our case, but I would see this as a problem in scenarios where users had a hybrid SharePoint environment.
Anyway, some small step for mankind .....