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 .....
You can refer to the article to see if it helps:
Disclaimer: Microsoft provides no assurances and/or warranties, implied or otherwise, and is not responsible for the download you receive from the third-party linked sites or any support related to the download or the downloading technology. If you need support relating to the third party technology, please contact the manufacturer directly.
Thanks for your understanding.
edit by Chris McClellan : business link removed, not allowed on this site