On the 4th may 2019, I have participated to the second Meetup of the Algeria modern Excel and Power BI UG which was held in the IB-Solutions headquarter.
During this meetup I had the honor to make a demonstration on how to make web scraping by using Power BI and R.
In this demonstration I tough the audience how to scrape a data form 2 websites by using the new web connector features of Power BI then combine them into 1 data table. Then I did the same web scraping by using the R package RVEST in RSTUDIO. And finally, I presented to the audience how to use R in Power BI and I showed how to execute the script created in RSTUDIO in Power BI.
You can download hereafter the presentation, the R script and the PBIX (Power BI) file created during the meetup :
It was a great experience with people who share the same interest in Power BI and Excel.
The general presentation of the meetup can be find here in the blog of my friend and the administrator of the group Mehdi. Here
Hope that the next meetup will be organized soon!