Extracted Raw file with formula

Good day!

Still building power bi report but im having trouble with the daily raw data extracted to excel have formulas and power bi treat this as error. Is there any possible way to get the values of that from power bi so that i can automate the daily report or do i really need to manually copy and paste as values in excel before importing the raw data to power bi? TIA!