Refresh Power BI in Power BI Service

Show a sanitized version of the Power Query code that is causing the issue.  There are ways to mask the dynamic part of the query  to trick the Power BI service into accepting the refresh request.

Hi Analitika ,

Power BI datasets that use dynamic data sources cannot be refreshed in the Power BI service. The only way to work around this is to use the RelativePath and Query options with the web.Contents M function. Queries that reference Power Query parameters can also be refreshed.

Please refer to the following link which will be helpful to you.

Solved: Refresh dynamic data source - Microsoft Power BI Community

Best Regards,
Community Support Team _ xiaosun

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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