How do I import in from power query the pages that has multiple pages
From webpage I insert url , I click inside the table, but import the first page only in power query
Storage Guide – Cargo Handling Corporation (chcl.mu)
I have search on the web
Scrape Data from Multiple Web Pages with Power Query • My Online Training Hub but it has not the start function
Storage Guide – Cargo Handling Corporation
1 [ 2 ][ 3 ][ 4 ][ 5 ][ 6 ][ 7 ][ 8 ][ 9 ] Next>>
Code
let
Source = Web.Page(Web.Contents("https://www.chcl.mu/storage-guide/")),
Data0 = Source{0}[Data],
#"Changed Type" = Table.TransformColumnTypes(Data0,{{"ATP", type text}, {"VESSEL", type text}, {"CODE", type text}, {"VOYAGE", type text}, {"ACTUAL TIME OF ARRIVAL", type text}, {"DISCHARGE COMPLETE", type text}})
in
#"Changed Type"
Display More
Can anyone help how to import all the pages