Dynamic Query Parametrisation help

Hi!   I am having trouble with parametrisation of this query. It still is considered as dynamic data and can not be refreshed via PBI portal.   Any help would be appreciated.     let ...