his data source was improperly configured error while using hyperlink in looker studio

[vindhya3003]

While im trying to append  a hyperlink  for one field in looker studio it is throwing  data source is configueration error where the data source is spanner table. But while im using the same for bigquery it is working. Please help me on this , as my project data is totally relied on spanner.I have checked too, the hyperlink data type is also hyperlink only.