Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The 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.

Reply
setis
Post Partisan
Post Partisan

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?

 

1 ACCEPTED SOLUTION
mahoneypat
Microsoft Employee
Microsoft Employee

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





Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.


@mahoneypa HoosierBI on YouTube


View solution in original post

3 REPLIES 3
setis
Post Partisan
Post Partisan

@mahoneypat thank you so much!!

mahoneypat
Microsoft Employee
Microsoft Employee

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





Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.


@mahoneypa HoosierBI 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:

copykai_0-1670185833630.png


Am I doing something wrong or is it normal behaviour?

Best,
Kaj

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.