topic Re: How to increase data selection from website by date in Report Server

How to increase data selection from website by date

Anonymous — Wed, 05 Dec 2018 05:00:17 GMT

Does anyone know how to increase the date selection when pulling data from a website? I am trying to pull bond yield data from the following link to power query. But the default is set to a 1 month time range. Is there a way to change this? How do I adjust this selection to 1 year, 3 years, or 10 years?

The M code below is where I believe the answer to my question is. I just don't know how to edit it so that it changes the date selection.

let
Source = Web.Page(Web.Contents("https://www.investing.com/rates-bonds/chile-10-year-bond-yield-historical-data")),
Data0 = Source{0}[Data],
#"Changed Type" = Table.TransformColumnTypes(Data0,{{"Date", type date}, {"Price", type number}, {"Open", type number}, {"High", type number}, {"Low", type number}, {"Change %", Percentage.Type}})
in
#"Changed Type"

Thank you for any help on this!

Re: How to increase data selection from website by date

v-danhe-msft — Fri, 28 Dec 2018 09:11:18 GMT

Hi @Anonymous,

Based on my test, you could refer to below code in advanced editor:

(para as text) as table =>
let
Source = Web.Page(Web.Contents("https://www.investing.com/rates-bonds/chile-"&para&"-year-bond-yield-historical-data")),
Data0 = Source{0}[Data],
#"Changed Type" = Table.TransformColumnTypes(Data0,{{"Date", type date}, {"Price", type number}, {"Open", type number}, {"High", type number}, {"Low", type number}, {"Change %", Percentage.Type}})
in
#"Changed Type"

And click the “Done”, you are able to enter the parameter to change different source:

After enter the “10” number:

You could also download the pbix file to have a view.

Regards,

Daniel He

Re: How to increase data selection from website by date

vicentetic — Thu, 09 Nov 2023 15:59:49 GMT

It's very interesting and it works but I think that the original author refers to change the values of the date box inside because the number "10" is part of the name and doesn't change. This is the place I'm talking about:

In this box you can change the date and extend the period. For example, can you do it for a period from 1/1/2020 - today ?