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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It 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
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

April Fabric Community Update

Fabric Community Update - April 2024

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

Top Solution Authors
Top Kudoed Authors