This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Do you use Alteryx in a language other than English? If so, we want to hear from you! Please help us improve the international experience of our products by participating in this 5 minute survey.
We are updating the requirements for Community registration. As of 7/21/21 all users will be required to register a phone number with their My Alteryx accounts. If you have already registered, you will be prompted on your next login to add your phone number.
I am trying to connect to an excel file in sharepoint in office 365. However, when I enter the address in Sharepoint connector in Alteryx Designer, I am getting an error "Root not found". How can I connect to an excel file on Sharepoint?
This doesn't work as well as it used to for a couple of reasons. First, Microsoft Explorer is no longer supported and doesn't work well (or at all) with the new versions of SharePoint. If you have the ability to use OneDrive (see below in this string) I have found this useful in accessing files from SharePoint for bringing into workflows. This doesn't work well with Server, however, as the OneDrive would need to be set up in the Server location with the correct access. I am still looking for a better solution, but if you are using SharePoint as a file repository then absent an as yet to be created SharePoint File Input tool OneDrive has been the best solution.
Hi @T_Willins , thankyou for this useful article. However i can able to load .xlsx and .csv file(Both Contains 15k Records) in alteryx desktop through sharepoint , but could not be able to load .csv or .xlsx file(Having 20 Lakhs record) because of error "The file exceed size limit and cannot be saved". I knew there is an excel limit to read or write data in .xlsx format is around ~ 11 lakhs, but there is no limit for .csv file to read or write. Same .csv file i have downloaded from share point and it ran perfectly in alteryx.
Could you please help me to troubleshoot this error.
Syncing Sharepoint excel files to your one drive can be a good option but for that your one drive has to be synched before workflow runs and for that it has to be ON for syncing. I was able to develop a workflow to download sharepoint excel files using API download process..