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 c...
Need Help
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?