Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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=25560...",", 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
Solved! Go to Solution.
Try using the RelativePath and Query options in Web.Contents. See this post for details.
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Hi, did you ever get this working? I'm trying to do the same thing. I can't get the RelativePath solution to work. Wondering if there's something obvious I'm missing.
Try using the RelativePath and Query options in Web.Contents. See this post for details.
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.