Refresh Power BI in Power BI Service

lbendlin 

What is a dynamic part, is it function? For example, in my Power BI

(DSN ) =>

let

Lentele = "VIDP",
Source = Odbc.Query("dsn=" & DSN,"select [_].[ZU0_KOD],#(lf) [_].[DID_NR],#(lf) [_].[ADM_VAR],#(lf) [_].[DID_DAT],#(lf) [_].[Eil. skaicius]#(lf)from #(lf)(#(lf) select [rows].[ZU0_KOD] as [ZU0_KOD],#(lf) [rows].[DID_NR] as [DID_NR],#(lf) [rows].[ADM_VAR] as [ADM_VAR],#(lf) [rows].[DID_DAT] as [DID_DAT],#(lf) count(1) as [Eil. skaicius]#(lf) from #(lf) (#(lf) select [$Outer].[ZU0_KOD],#(lf) [$Outer].[DID_NR],#(lf) [$Outer].[ADM_VAR],#(lf) [$Outer].[DID_DAT]#(lf) from #(lf) (#(lf) select [_].[ID_VIDP] as [ID_VIDP2],#(lf) [_].[ZU0_KOD] as [ZU0_KOD],#(lf) [_].[DID_NR] as [DID_NR],#(lf) [_].[ADM_VAR] as [ADM_VAR],#(lf) [_].[DID_DAT] as [DID_DAT]#(lf) from [DBA].[VIDP] [_]#(lf) where [_].[DID_DAT] >= '" & sFilterDate & "'#(lf) ) [$Outer]#(lf) left outer join [DBA].[VIDP1] [$Inner] on ([$Outer].[ID_VIDP2] = [$Inner].[ID_VIDP])#(lf) ) [rows]#(lf) group by [ZU0_KOD],#(lf) [DID_NR],#(lf) [ADM_VAR],#(lf) [DID_DAT]#(lf)) [_]")
in
Source