Refreshing Datasets Error Message

Rachael

Hi,

I recently updated the credentials for an external system, and when refreshing some of the tables a few of the columns have been removed. Previously this hasn't been a problem because I can just configure the tables, but since we upgraded I've been getting the following message:

Screenshot 1: Notification that there are changes

Screenshot 2: Error message which comes up

Any help would be great! The only way around it I've found so far is deleting the old dataset and adding it back in.

Thanks

@SpeedySteven tagging you for info

Josh Boxer

Hi Rachel

What type of database is this you are connecting to?

If you know that the columns are missing then you can 'Annotate columns' of the Dataset and set them to Optional before hitting refresh.

We will investigate the error message you are getting

Rachael

Hi Josh,

It's a SQL server database. Will try that workaround for now, thanks

Rachael

Ian Hayden

Hi @Rachael, could you send me your datastudio.log file so I can look into this more. Please send to [email protected] and I will be in touch.

Many thanks,

Ian

Rachael

Hi @Ian Hayden, just sent that over to you

Thanks

Rachael