Forum Discussion

Martin_MG's avatar
Martin_MG
Frequent Visitor
5 years ago

Web page word counting

I am using power query through power bi to connect to a web page. yahoo.com in general, could be other pages also. I wanted to count how many times "Covid" appeared on a page. I tried using the web connector and looking at several blog. Couldnt figure it out. Any help is appreciated. 

Need Help

2 Replies

  • Fowmy's avatar
    Fowmy
    Super User
    5 years ago

    Martin_MG 

    I tried it and it worked for me. Connected to this page https://docs.microsoft.com/en-us/power-bi/guidance/whitepaper-powerbi-security

    from Power Query and counted the word "Power BI", it appears 306 times. I added a column and counted the occurrences of the word. Paste the below code in a blank query and replace the link and the search word.

    let
    Source = Web.BrowserContents("https://docs.microsoft.com/en-us/power-bi/guidance/whitepaper-powerbi-security"),
    #"Converted to Table" = #table(1, {{Source}}),
    #"Added Custom1" = Table.AddColumn(#"Converted to Table", "Custom.1", each List.Count(Text.PositionOf([Column1],"Power BI",Occurrence.All )))
in
    #"Added Custom1"



    ________________________

    If my answer was helpful, please consider Accept it as the solution to help the other members find it

    Click on the Thumbs-Up icon if you like this reply 🙂

    YouTube  LinkedIn

     

    • Martin_MG's avatar
      Martin_MG
      Frequent Visitor
      5 years ago

      I got the same results on the microsoft site. I have been tring the (Web.BrowserContents("https://www.yahoo.com/") on yahoo. With Failed results. attaching photos. When you web connect /  add tables using examples, this show that there are multiple refrences of covid on the page. If you use the query you supplied the query only returns a value of 1. Some pages it works and some it does not?