Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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?
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
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.
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.
Actually I don't see Query 1 in my Power BI.
Where does sFilterDate come from?
It looks like this:
Actually I have many functions:
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.
User | Count |
---|---|
90 | |
84 | |
66 | |
62 | |
57 |
User | Count |
---|---|
138 | |
112 | |
94 | |
82 | |
71 |