Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! It's time to submit your entry. Live now!
Hi,
I am trying to download olympic events details from html pages. I am trying invoke a function, which extracts a table from html pages. I want pass page number as variable. All the html pages has this table 'Competiors' . This table has 11 columns, for some events some columns are not relevant- so the additional columns are named as column10 and column11.
The below are some urls
After creating a function when i pass a page number i get an error, What is this error? and How can i resolve it?
(Page as number) as table =>
let
Source = Web.Page(Web.Contents("https://data.fis-ski.com/dynamic/results.html?sector=AL&raceid=" & Number.ToText(Page))),
Data4 = Source{4}[Data],
#"Changed Type" = Table.TransformColumnTypes(Data4,{{"Rank", type text}, {"Bib", type text}, {"FIS Code", type text}, {"Name", type text}, {"Year", type text}, {"Nation", type text}, {"Run 1", type text}, {"Run 2", type text}, {"Total Time", type text}, {"Diff.", type text}, {"FIS Points", type text}})
in
#"Changed Type"
Solved! Go to Solution.
@F75,
You may change it as follows.
#"Filtered Rows" = Table.SelectRows(Source, each ([Caption] = "Competitors")),
Data = #"Filtered Rows"{0}[Data]
in
Data
@F75,
You may change it as follows.
#"Filtered Rows" = Table.SelectRows(Source, each ([Caption] = "Competitors")),
Data = #"Filtered Rows"{0}[Data]
in
Data
| User | Count |
|---|---|
| 53 | |
| 40 | |
| 35 | |
| 24 | |
| 22 |
| User | Count |
|---|---|
| 135 | |
| 111 | |
| 57 | |
| 44 | |
| 38 |