Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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?
Solved! Go to 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
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
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
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
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
User | Count |
---|---|
16 | |
10 | |
9 | |
9 | |
8 |
User | Count |
---|---|
23 | |
17 | |
12 | |
12 | |
12 |