Forum Discussion
Dynamic Parameter of column value
Hi,
I would like to update the source files of my report directly via web source.
= Csv.Document(Web.Contents("https://www.covid19.admin.ch/api/data/20210426-73ottdu4/sources/COVID19Cases_geoRegion.csv"),[Delimiter=",", Columns=50, Encoding=1252, QuoteStyle=QuoteStyle.None])
Therefore I have addes a web source. One part of the url will change daily (see red marked). Thats why it must be dynamically.
Is it possible to get the value of the field dataVersion into parameter? So this part of the url will change dynamically?
Hi Anonymous ,
Pls check whether below blog help:
Best Regards,
KellyDid I answer your question? Mark my post as a solution!
1 Reply
- v-kelly-msftCommunity Support
Hi Anonymous ,
Pls check whether below blog help:
Best Regards,
KellyDid I answer your question? Mark my post as a solution!