I've had an issue pop up several times now where I'll refresh my extracts for a dashboard I've created, and then suddenly one or two of my variables will read as all nulls. When I go to "Data source", I get an error, and these errors vary. Some are invalid table name errors, some are insertdata unbound column errors. When I click "Data > Refresh data source", it fixes the problem. This has happened in multiple workbooks several times over the last couple of months.
Is there a reason this issue is coming up in the first place, and is there anything I can do so it doesn't keep happening? Is it a Tableau bug or something I'm not structuring well on my end?
#Tableau Desktop & Web Authoring
Thank you! Generally this happens after I've made an update to the data and need to refresh it in my dashboards. It's usually additional data being appended to an existing sheet, but because I do my data cleaning and appending in R, it will override the existing sheet with a fresh copy every time I run my script. But column and table names aren't changing between updates.
