Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
102 | |
53 | |
21 | |
13 | |
11 |