Welcome to the Dataiku community. We are so glad to have you with us.
Regarding Share Point, I’m not an expert on using it as a data source. However, I do know that there is a plugin that can be added to Dataiku Data Science Studio (DSS) for Share Point https://www.dataiku.com/product/plugins/sharepoint-online/ It may depend on how you have Dataiku installed. I’m not clear if the online version can have this as an added feature. However, if you have DSS and local install, or cloud install should be able to have this plugin installed.
There are also a few thread here on the topic. For example:
Others who have done this please jump in here.