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

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.

79b2fac9-e72b-45c9-bc7c-72fc05ecb8a2.png

spanner after.png

d7edbaf0-6dd4-4c6d-9de1-8dd2e32e188b.png

 

0 0 504