Forum Discussion

bepop's avatar
bepop
Regular Visitor
3 years ago

schedule refresh from web table not working

Hi,

 

Am unable to schedule refresh table from below link, site contains a currency exchange table

https://www.mcb.mu/en/corporate/

 

have also removed the "Browser" from below source but still now working

 

let
Source = Web.BrowserContents("https://www.mcb.mu/en/corporate/"),
#"Extracted Table From Html" = Html.Table(Source, {{"Column1", "TABLE.table.table\-\-decorated > * > TR > :nth-child(1)"}, {"Column2", "TABLE.table.table\-\-decorated > * > TR > :nth-child(2)"}, {"Column3", "TABLE.table.table\-\-decorated > * > TR > :nth-child(3)"}}, [RowSelector="TABLE.table.table\-\-decorated > * > TR"]),
#"Promoted Headers" = Table.PromoteHeaders(#"Extracted Table From Html", [PromoteAllScalars=true]),
#"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"Currency", type text}, {"Buy", type number}, {"Sell", type number}})
in
#"Changed Type"

 

any idea?

No RepliesBe the first to reply