Dynamic Parameter of column value

[Anonymous]

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"),[Delimi..., 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?

Thanks a lot

[v-kelly-msft · Accepted solution]

Hi  @Anonymous ,

Pls check whether below blog help:

https://answers.microsoft.com/en-us/msoffice/forum/all/power-query-get-transform-dynamic-columns-part-i/5b528142-b58f-42cb-b314-4c5fa28a55f5

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!