Today date on url

[setis]

Dear experts, 

I'm trying to dynamically change the date on the url https://www.xe.com/currencytables/?from=DKK&date=2021-04-12#table-section to TODAY() with the correct format

let
    Source = Web.Page(Web.Contents("https://www.xe.com/currencytables/?from=DKK&date=2021-04-12#table-section")),
    Data0 = Source{0}[Data]
in
    Data0

Is it possible? How can achieve this?

[setis]

@mahoneypat thank you so much!!

[mahoneypat · Accepted solution]

You can this expression to dynamically add today's date.

"https://www.xe.com/currencytables/?from=DKK&date=" & Date.ToText(Date.From(DateTime.LocalNow()), "yyyy-MM-dd") &"#table-section"

Regards,

Pat

[copykai]

Hi Pat
I did the exact same thing but when I publish to Power BI Service it isnt able to refresh and gives this issue:

Am I doing something wrong or is it normal behaviour?

Best,
Kaj