Hi, facing issue in data pulling

[jimmybalti]

after loading i get only data from 1st page and other 19 pages are showing zero.

but in other it says empty:

kindly please advice. am a beginner.

here is the syntax i used.

(Pagestart as text)=>
let
Source = Web.BrowserContents("https://www.expert-seo-training-institute.in/blog/guest-posting-sites/"&Pagestart&"/"),
#"Extracted Table From Html" = Html.Table(Source, {{"S.no", "TABLE[id='tablepress-408'] > TBODY > TR > :nth-child(1)"}, {"website", "TABLE[id='tablepress-408'] > TBODY > TR > :nth-child(2)"}, {"link location", "TABLE[id='tablepress-408'] > TBODY > TR > :nth-child(3)"}}, [RowSelector="TABLE[id='tablepress-408'] > TBODY > TR"]),
#"Changed Type" = Table.TransformColumnTypes(#"Extracted Table From Html",{{"S.no", type text}, {"website", type text}, {"link location", type text}})
in
#"Changed Type"

[Anonymous · Accepted solution]

Hi @jimmybalti ,

I cannot reproduced you issue. Please have a try.

let
    Source = Web.BrowserContents("https://www.expert-seo-training-institute.in/blog/guest-posting-sites/"),
    #"Extracted Table From Html" = Html.Table(Source, {{"Column1", "TABLE[id='tablepress-630'] > * > TR > :nth-child(1)"}, {"Column2", "TABLE[id='tablepress-630'] > * > TR > :nth-child(2)"}, {"Column3", "TABLE[id='tablepress-630'] > * > TR > :nth-child(3)"}}, [RowSelector="TABLE[id='tablepress-630'] > * > TR"]),
    #"Promoted Headers" = Table.PromoteHeaders(#"Extracted Table From Html", [PromoteAllScalars=true]),
    #"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"S.No.", type date}, {"Website", type text}, {"Link Type", type text}})
in
    #"Changed Type"

Extract data from a Web page by example in Power BI Desktop - Power BI | Microsoft Learn

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards
Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.