EDIT Formula Query

[Anonymous]

Hi,

 I remove the  id and update date  filde from datawerhouse and I want to refrlct that  in  power query in power  BI BASED ON THE  BELOW  IMAGE ,

how I can EDIT Formula  to select other fildes without  id  and Updatedate if the names for others fildes A,B,C and D

[v-yulgu-msft]

Hi @Anonymous,

Since you have removed ID and UpdateDate fields from data source, you need to edit the M code under Advanced Editor, to remove the reference to these two fields.

Regards,

Yuliana Gu