Refresh Power BI in Power BI Service

[Analitika]

Hi,

I would like to ask how to fix that I could refresh Power BI in Power BI Service. For now I can't setup schedule refresh, getting this message:

This dataset includes a dynamic data source. Since dynamic data sources aren't refreshed in the Power BI service, this dataset won't be refreshed. Learn more: https://aka.ms/dynamic-data-sources.
Data source for Query1

So how to resolve this issue?

[Analitika]

@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

[v-xiaosun-msft]

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]

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.

[Analitika]

Actually I don't see Query 1 in my Power BI.

[lbendlin]

Where does sFilterDate come from?

[Analitika]

It looks like this:

Actually I have many functions:

[lbendlin]

Try to inline that.  Use the raw code in your query rather than the reference.  That way you may be able to avoid the partitioning.