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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

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
Employee
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
Employee
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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

Top Solution Authors
Top Kudoed Authors