Extracted Raw file with formula

[xRTP]

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!

[v-luwang-msft]

Hi @xRTP ,

Could you please share us some sample data and expected output result which can help us make some tests and get the right direction?

Best Regards

Lucien