Click here to go to “All the World (Wide Web)”
This project is derived from an eye catching video from MBAS 2019 on Power Query. “Microsoft Power BI: Connect and transform data from hundreds of data sources using Power Query.” After connecting to the web site using the web connector, I selected the table with the data, promoted the first row to header, removed other columns, re-titled each column, removed the totals.
As the data is spread across multiple pages, I created a parameter to represent the page number, then created a list and a table to harvest all pages. This is rolled into a custom function and invoked in the final query. In the dashboard I added some conditional formatting on the columns; “Total Gross” and “Theaters” to show that the gross did not correlate directly to the number of theaters in which the movie played.
Nathaniel Cohen 