Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I have a query that is based on a web address.
the address changes based on the date
is there a way of inputting the date required?
which then can be 'sculptured' to load the correct web page?
Solved! Go to Solution.
Hi @Anonymous,
Based on my test, you could refer to below formula in Advanced language in query editor:
(para as date) as table => let Source = Web.Page(Web.Contents("https://www.accuweather.com/en/sg/singapore/300597/december-weather/300597?monyr="¶)), Data0 = Source{0}[Data], #"Changed Type" = Table.TransformColumnTypes(Data0,{{"Sunday", type text}, {"Monday", type text}, {"Tuesday", type text}, {"Wednesday", type text}, {"Thursday", type text}, {"Friday", type text}, {"Saturday", type text}}) in #"Changed Type"
See the highliaght code, after you have applied it, you could choose the data to invoke the function:
In this example, I need to ues the text due to I have not found the situable web source:
Result:
Regards,
Daniel He
Hi @Anonymous,
Could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered to close this topic?
Regards,
Daniel He
Hi @Anonymous,
Based on my test, you could refer to below formula in Advanced language in query editor:
(para as date) as table => let Source = Web.Page(Web.Contents("https://www.accuweather.com/en/sg/singapore/300597/december-weather/300597?monyr="¶)), Data0 = Source{0}[Data], #"Changed Type" = Table.TransformColumnTypes(Data0,{{"Sunday", type text}, {"Monday", type text}, {"Tuesday", type text}, {"Wednesday", type text}, {"Thursday", type text}, {"Friday", type text}, {"Saturday", type text}}) in #"Changed Type"
See the highliaght code, after you have applied it, you could choose the data to invoke the function:
In this example, I need to ues the text due to I have not found the situable web source:
Result:
Regards,
Daniel He
User | Count |
---|---|
70 | |
70 | |
34 | |
23 | |
22 |
User | Count |
---|---|
96 | |
94 | |
50 | |
42 | |
40 |