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"

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

praveenjujare

Helper I

2 years ago

Solved

dynamic data sources aren't refreshed

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}})

#"Changed Type"

Need Help