Forum Discussion
Today date on url
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?
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
3 Replies
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
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
mahoneypat thank you so much!!
