Formula on Data studio

I would like to create a dashbord on datastudio with a google sheet for database.
In my Sheet file, numbers above 999 are recognized as text.
After trying all the formulas below I can't get them to appear as numbers.
CAST(REPLACE(Price," ","") AS NUMBER)
CAST(REGEXP_REPLACE(Price,' ','') AS NUMBER)
CAST(REGEXP_REPLACE(Price,'[ ]','') AS NUMBER)
CAST(REGEXP_REPLACE(Price,'\\+','') AS NUMBER)
CAST(REGEXP_REPLACE(Price,'\\s+','') AS NUMBER)
CAST(REGEXP_REPLACE(Price,'(.*)\s(.*)','\\2 \\1') AS NUMBER)
CAST(REGEXP_REPLACEPrice,'(.*)[ ](.*)','\\2 \\1') AS NUMBER)
cast (TRIM(REGEXP_REPLACE(Price, "\\s+", " ")) as NUMBER)
trim(replace(Replace(Price,'€',''),' ',''))

Would you have a solution?
The formula must be created only on Data studio.
It is forbidden to modify the data on Google sheet or to create a formula on G sheet
The link Google sheet : https://docs.google.com/spreadsheets/d/1QMW7i9LKlRcGTzKCAnt_Cm7tOBmbSqxWLvi3TK0sN7A/edit#gid=0