![]() ![]() To motivate you to keep reading, here is the Power BI report, that I could prepare with the data that was extracted in the page above.īefore we start our challenge, let’s briefly review the simple scenario, when the import of tables is easy. We will demonstrate the technique by web scraping the Microsoft Find an MVP search results here. The good news is that you’ll not need prior knowledge of HTML. In today’s blog post, I will share a technique that will allow you to scrap tables from web pages, by navigating the web page elements in the Query Editor, and mastering the craftsmanship of Childrenexpansion. Have you ever encountered the following dead-end experience, with no tables to import? While it’s easy to import static tables from many websites in Power BI and Excel Power Query, you’ve probably found out by now that in too many cases, the tables you want to import are illusive, and inaccessible in Power BI. Follow are abundant public data sources on the Web, and it is so tempting to import and mash them up with your existing datasets in Power BI and Excel Power Query to gain new correlations and insights. ![]()
0 Comments
Leave a Reply. |