-
1. Re: Issue with the UNC path of an Excel file located in SharePoint drive
Jeff StraussJan 25, 2017 8:11 AM (in response to abdelmajid elmounjid)
make sure that your Tableau Server runas user account has access to this file location.
-
3. Re: Issue with the UNC path of an Excel file located in SharePoint drive
Toby ErksonJan 26, 2017 8:18 AM (in response to abdelmajid elmounjid)
What version of SharePoint?
-
4. Re: Issue with the UNC path of an Excel file located in SharePoint drive
abdelmajid elmounjid Jan 26, 2017 10:08 AM (in response to Toby Erkson)2013,
Thank you
-
5. Re: Issue with the UNC path of an Excel file located in SharePoint drive
Toby ErksonJan 26, 2017 11:40 AM (in response to abdelmajid elmounjid)
Please see this: Tableau Server cannot connect to SharePoint 2013 but Desktop can. Why? Need help connecting.
SharePoint 2013 has been radically changed since version 2010 so you can thank Microsoft for screwing that up.
More issues/complaints about this here: https://community.tableau.com/search.jspa?q=sharepoint%202013
-
6. Re: Issue with the UNC path of an Excel file located in SharePoint drive
abdelmajid elmounjid Jan 30, 2017 7:03 AM (in response to Toby Erkson)Hi Toby,
I am not connecting to OData, I am getting the data from Excel that is hosted in SharePoint, I am able to publish fine but whenever I update the data in the Excel sheet, I don't see the updates happening at the server level when I hit refresh.
Thank you Toby,
-
8. Re: Issue with the UNC path of an Excel file located in SharePoint drive
abdelmajid elmounjid Jan 30, 2017 9:37 AM (in response to Jeff Strauss)I just tried that too, and still the data is not updating at the server lever,
any ideas?
Thank you
-
9. Re: Issue with the UNC path of an Excel file located in SharePoint drive
Jeff StraussJan 30, 2017 10:18 AM (in response to abdelmajid elmounjid)
make sure it's not getting it from cache. You can hit CTRL+F5 or hit the refresh button.
-
10. Re: Issue with the UNC path of an Excel file located in SharePoint drive
Toby ErksonJan 30, 2017 10:58 AM (in response to abdelmajid elmounjid)
It's my understanding that objects are not stored in a folder like they used to be in prior versions of SharePoint so it's no longer a simple matter to get the item of desire i.e. a UNC file path.
The link I provided earlier had more info than just OData.
-
11. Re: Issue with the UNC path of an Excel file located in SharePoint drive
Mark ODonnell Jan 31, 2017 9:24 AM (in response to abdelmajid elmounjid)Have you tested the connection from the data and background servers while logged in with your tableau runas ID?
We had the same issue and found that after manually connecting from the server the workbook and extract connections were working. This was explained to me as an issue with cross authentication and timeouts.
I wrote a small powershell script which manually initializes a connection to a SharePoint repository once a day before the schedules run. This was enough to fix the issue.
-
12. Re: Issue with the UNC path of an Excel file located in SharePoint drive
John Maschke Jan 31, 2017 8:32 PM (in response to abdelmajid elmounjid)first off...my first suggestion would be to leverage a SharePoint list/table for your data as its a far more controlled environment then an excel sheet hosted within it. From a data management perspective, its easy to connect to the list through an OData link and do a nightly batch refresh (that's how i run a lot of these).
there could be an issue with the SharePoint farm the server resides on that is blocking the connection to the excel file, i know we have an antivirus program that was blocking some connections on our, but that was for OneNote.
you can also try and open your document library in the explorer window...most links if you reverse the forward slash to a backslash you get the directory views..more like a shared folder, or explorer view. I will test out a similar case tomorrow, and let you know is i get the same results.
John