Forum Discussion
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?