dynamic data sources aren't refreshed

[praveenjujare]

This dataset includes a dynamic data source. Since dynamic data sources aren't refreshed in the Power BI service

(stockquotes as text)as table =>

let

    EndDate= Number.Round(Duration.TotalSeconds(DateTime.LocalNow()- #datetime(1970,1,1,0,0,0)),0),

    Source = Csv.Document(Web.Contents(https://query1.finance.yahoo.com/v7/finance/download/&stockquotes&"?period1=1565827200&period2=" & Text.From(EndDate) & "&interval=1d&events=history&includeAdjustedClose=true"),[Delimiter=",", Columns=7, Encoding=65001, QuoteStyle=QuoteStyle.None]),

    #"Promoted Headers" = Table.PromoteHeaders(Source, [PromoteAllScalars=true]),

    #"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"Date", type date}, {"Open", type number}, {"High", type number}, {"Low", type number}, {"Close", type number}, {"Adj Close", type number}, {"Volume", Int64.Type}})

in

    #"Changed Type"

[lbendlin · Accepted solution]

Please follow the documentation. Use RelativePath and Query parameters. https://learn.microsoft.com/en-us/powerquery-m/web-contents#example-1

[praveenjujare]

Thanks @lbendlin 

[Anonymous · Accepted solution]

Hi @praveenjujare ,

Thanks for lbendlin's reply !
There have been many users asking the same question, you may find a useful solution in it. I found the following relevant links for you:
Solved: Unable to refresh Dynamic Data Sources - Microsoft Fabric Community
Solved: Dynamic data sources aren't refreshed in the Power... - Microsoft Fabric Community
Solved: This dataset includes a dynamic data source. Since... - Microsoft Fabric Community
Solved: Help: Dataset includes a dynamic data source error - Microsoft Fabric Community

Best Regards,
Dino Tao

[praveenjujare]

Thanks  @Anonymous 

[lbendlin · Accepted solution]

Please follow the documentation. Use RelativePath and Query parameters. https://learn.microsoft.com/en-us/powerquery-m/web-contents#example-1