shedvur.blogg.se

Specify a new location for the underlying data source in the workbook by editing the data source. Right-click the data source in the Data window, and then select Properties to check the directory path expected by the workbook. ProblemĮxpected Excel or text file not being usedĮxpected Excel or text file not being usedThe directory path to the Excel or text file is different from the path specified in the workbook. Tableau Desktop is unable to upgrade a data source if information has changed or missing from the underlying data source. Depending on your needs, you might consider not upgrading the data source. To resolve issues that prevent data source upgrades, evaluate whether one of the conditions listed below applies to one of the affected data sources in your workbook and try the suggested resolution. Notification about data sources that could not be upgraded Try removing filters or calculations that might depend on field that contains the #N/A error. The marks in your view rely on an Excel file that contains a #N/A error that is treated as a string data type.ĭata type has changed – a #N/A error was previously treated as a string but is now treated as a null.

You can ignore the change or try deleting the calculation. View looks different or shows different dataĪ calculated field in the view is used to convert a field that is a number data type to a string data type.Ī calculated field in the view is used to convert a field that is a string data type to a date data type.ĭata type has changed - the string field was previously treated as a string but is now treated as a date data type. Try removing calculation from the view or rewriting the calculation.

You are using a calculation that multiplies a field that is a number data type.ĭata type has changed – the field was previously treated as a number but is now treated as a string data type. Right-click the red field and select Replace References to replace the invalid field with a valid field.

Refer to the following table for some common changes that you might see after a data source upgrade and some suggested solutions to help resolve any discrepancies in your workbook. Resolution Changes to the workbook after upgrading data sourcesĬhanges to your workbook can occur after upgrading Excel and text file data sources.