Tableau Smartsheet WDC -Unable To refresh smartsheet datasource in tableau server
I have a smartsheet sheet published as a datasource in tableau server. The initial connection to smartsheet from tableau desktop is made using WDC . the said WDC is enabled in the server with the refresh status also set as allowed.
This is the result for "tsm tsm data-access web-data-connectors list" command
Status: Enabled
Refreshes for Web Data Connector-based Data Sources: Enabled
Name URL Secondary
smartsheetconnector https://tableau.smartsheet.com/tableau:443/ https://tableau.smartsheet.com:443/.*
I am able to connect to the smartsheet from tableau desktop and publish a datasource to the tableau server , but whenever I am trying to refresh the datasource I am not able to do it with an error message as shown below
"This job failed on 1 Sep 2022, 12:41 PM after running for 0.0 min because of: java.lang.RuntimeException: An error occurred when refreshing extracts for the Datasource 'Smartsheet for Tableau'; Web Data Connector with URL https://tableau.smartsheet.com:443/tableau is not in the list of allowed web data connectors or does not have the correct configuration. Refresh skipped. For help, please refer to: https://help.tableau.com/current/online/en-us/to_keep_data_fresh.htm (errorCode=60007)"
Can anyone tell how can i fix this
Answers
-
Hi @vishal
Although you're using a Smartsheet Published link, this is actually a question for the Tableau Community.
I took a look at the documentation linked in the error message. From what I can see, the Web Data Connector has this documented:
"When you publish the data source or workbook to Tableau Server, you cannot refresh the extract on Tableau Server unless the web data connector is added to the safe list on Tableau Server. If the connector requires credentials to sign in to the web-based data source, you need to ensure that the credentials are embedded with the data source. For more information, see Web Data Connectors in Tableau Server in the Tableau Server Help."
Following the links here, I found this Tableau documentation to help you, see the heading: Add connectors to the safe list and secondary safe list
If you're having trouble with the steps above, please reach out to Tableau for further assistance.
Cheers,
Genevieve
