Forum Discussion

Neillson's avatar
Neillson
New Member
1 year ago
Solved

Generating Table from Website

Hi MS Fabric Community,

 

I am having trouble generating a table from the contact list found at the bottom porition of this URL: https://members.nathpo.org/thpodirectory/FindStartsWith?term=%23%21 

I would like to generate a new table with all data fields in a POWER BI.

 

Thanks for your help.

 

NM

Need Help
  • lbendlin's avatar
    lbendlin
    1 year ago

     

    let
    Source = Web.BrowserContents("https://members.nathpo.org/thpodirectory/FindStartsWith?term=%23%21 "),
    #"Extracted Table From Html" = Html.Table(Source, {{"Tribe", ".card-title *"}, {"Region", ".gz-cat"},  {"Address", ".gz-fa-map-marker-alt + *"}, {"Place", "[itemprop=""addressLocality""]"},{"State", "[itemprop=""addressRegion""]"}, {"ZIP Code", "[itemprop=""postalCode""]"}, {"Phone", "[itemprop=""telephone""]"},{"Web", ".gz-card-website > a", each [Attributes][href]}}, [RowSelector=".gz-list-col"])
in
    #"Extracted Table From Html"

     

    How to use this code: Create a new Blank Query. Click on "Advanced Editor". Replace the code in the window with the code provided here. Click "Done". Once you examined the code, replace the Source step with your own source.

2 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    1 year ago

     

    let
    Source = Web.BrowserContents("https://members.nathpo.org/thpodirectory/FindStartsWith?term=%23%21 "),
    #"Extracted Table From Html" = Html.Table(Source, {{"Tribe", ".card-title *"}, {"Region", ".gz-cat"},  {"Address", ".gz-fa-map-marker-alt + *"}, {"Place", "[itemprop=""addressLocality""]"},{"State", "[itemprop=""addressRegion""]"}, {"ZIP Code", "[itemprop=""postalCode""]"}, {"Phone", "[itemprop=""telephone""]"},{"Web", ".gz-card-website > a", each [Attributes][href]}}, [RowSelector=".gz-list-col"])
in
    #"Extracted Table From Html"

     

    How to use this code: Create a new Blank Query. Click on "Advanced Editor". Replace the code in the window with the code provided here. Click "Done". Once you examined the code, replace the Source step with your own source.