Hi,
I am able to connect to my excel file from tableau desktop using the correct path to it. However, I am experiencing and error at tableau server level (the error below)
Please advise on how to make the following path a UNC one:
"\\sites.bbbbb.aaaaaa.com@SSL\DavWWWRoot\p\dataviz\Shared Documents "
Thank you
Jan 25, 2017 8:11 AM
make sure that your Tableau Server runas user account has access to this file location.
Hi Jeff,
I have done that, published the new workbook to tableau server, update data in the excel file. However, when I hit refresh at the server level the data is not updating,
I check the logs and this is what found:
Thank you
Jan 26, 2017 8:18 AM
What version of SharePoint?
Jan 26, 2017 11:40 AM
Please see this:
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
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,
Jan 30, 2017 7:15 AM
here's something to try. It may apply to your situation.
When publishing a workbook that leverages Excel (or csv or txt data too), uncheck the "include external files". This in effect will allow Tableau to maintain the pointer to the UNC path and not store its own temp copy of the data.
I just tried that too, and still the data is not updating at the server lever,
any ideas?
Thank you
Jan 30, 2017 10:18 AM
make sure it's not getting it from cache. You can hit CTRL+F5 or hit the refresh button.
Jan 30, 2017 10:58 AM
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.
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.
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