Web scrape info from this Community Notification Feed page to Power BI

[vojtechsima]

Hello,

I am trying to do some statistics about my notification panel in this community:
https://community.fabric.microsoft.com/t5/notificationfeed/page

I was wondering if there's a way how to access it.

I thought about scraping the page on a regular basis through Power BI (naturally); however, I am not sure how to apply the authentication. Do you have any advice or a different approach?

Thank you

[v-mengmli-msft · Accepted solution]

Hi @vojtechsima ,

You can try writing a crawler in Python that will crawl pages of website that require authentication by simulating login. If the website uses a more sophisticated authentication mechanism, such as multi-factor authentication, you may need to use a browser automation tool, such as Selenium, to handle the login process. After you save the captured data as a CSV file, you can import it into PowerBI for analysis.

The above requires knowledge of different fields, and I suggest you contact the relevant professionals.

Best regards,

Mengmeng Li

[VahidDM]

Hi @vojtechsima 

Most of the data you seek is available on the Profile page. What exactly are you looking? 

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

Appreciate your Kudos!! 

LinkedIn|Twitter|Blog |YouTube 

[vojtechsima]

@VahidDM 
I'd like to historize it for my own personal challenge, so I can see in what months or weeks I was most active etc. But naturally, the date is there, however, I don't wanna manually write it down.