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?