This data source was improperly configured error while using hyperlink in Spanner Table

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

Spanner Error:

vindhya3003_0-1722408722430.png

Spanner without Hyperlink field:

vindhya3003_2-1722408833916.png

vindhya3003_3-1722408871028.png

vindhya3003_5-1722409000201.png

Working in Bigquery :

vindhya3003_1-1722408755139.png

 

0 0 1,113