Loading to Power Query but keep formulas in cells

[danhendo888]

[FONT=Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif]

Book1
	B	C	D	E
1	Invoice	Date	Amount	Booked
2	M0121032	19-Mar-19	101.48	Booked
Coynes

Cell Formulas
Range	Formula
E2	=IFNA(IF(MATCH("*"&B2&"*",'[22.07.2019 Consolidated.XLSX]Sheet2'!K:K,0)>0,"Booked","Not Booked"),"Not Booked")

Hello,
I would like to load this table into power query.
When I go to Data ribbon -> From Table, it only displays the values and not the formulas.
How do I keep the formulas within my tables?
Thank you
​

[/FONT]

 

[sandy666]

formula doesn't work in PowerQuery
PowerQuery works with data
PowerQuery doesn't change your source table so you have your formula there