Yahoo finance refresh in PBI Service

Hi all,

i am currently building a dashboard to manage financial assets and added date from yFinance as well. While everything works fine in Desktop, i cant schedule autorefreshs in PBI Service since i am using "dynamic sources" which are not yet supported

I am using shown query to get the data. As you can see i added some parts to allow etraction of more than one stock at once but can't figure out how to make the autorefresh work. I guess i must adjust the period within the weblink somehow?

= (stockquote as text) as table =>

let
Quelle = Csv.Document(Web.Contents("https://query1.finance.yahoo.com/v7/finance/download/"&stockquote&"?period1=1564617600&period2=2556057600&interval=1d&events=history&includeAdjustedClose=true"),[Delimiter=",", Columns=7, Encoding=1252, QuoteStyle=QuoteStyle.None])
in
Quelle

Has anyone experienced this is might now how to fix it? Or is autorefreshing just not an option with this data set?

Best regards

Stefan