Loading

La jointure entre bases de données Excel n'affiche pas les données mises à jour lors de l'actualisation

Date de publication: Aug 24, 2022
Description
Cross-database join with Excel external files included will not refresh correctly.

Cause

Because the dataset is based off of a subset of the Excel file, the "Include external files" option does not include a complete Excel file. If the external files are not included (but are on a shared location for example) when the dataset is refreshed, Tableau reaches out to the location of the Excel file for the extract refresh.

 
Résolution
Deselect "Include External Files" when publishing the joined data.
  1. Go to Server > Publish Workbook. 
  2. Uncheck the box next to "Include external files."
  3. Select Publish.
When unchecking the box for "Include external files," then Tableau Server can access the Excel file directly for refreshing the data. Otherwise, if "Include External Files" is selected when publishing, a copy of the data from Excel is included with the workbook and is static data and will not refresh. 
Numéro d’article de la base de connaissances

001471588

 
Chargement
Salesforce Help | Article