Loading

Un join Excel tra database non mostra i dati aggiornati all'aggiornamento

Data pubblicazione: Aug 24, 2022
Descrizione
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.

 
Risoluzione
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. 
Numero articolo Knowledge

001471588

 
Caricamento
Salesforce Help | Article