Column format changes automatically while adding up data source in Looker Studio

[studious]

Hi, there! Everyone!

Recently, I have been facing an issue while connecting my DataSource (google sheets) with Looker Studio. I have 2 currency ($ USD) columns in my spreadsheet file of google sheets but when I try to connect the DataSource with Looker studio, the "Currency" format column automatically changes to "Number" format.

Although I know that I can manually change this format later on back to the currency format, but I want it to automatically captures right data format from spreadsheet file.

So, does anyone knows why this format issue is coming up and how to solve it permanently?