Power BI + NZ Company register

Update: The ArcGIS map doesn't work for embedded, so had to switch to the default bing map. As a result some addresses aren't located correctly.

For my first post I thought I’d share something I learnt this week at the Excel and Power BI user group in Wellington (a group I can't recommend enough!).

Jeff Weir, presenter, walked us through a demo of the new and improved web scrapper introduced in the May 2018 update (so make sure you have updated your desktop app to test this out yourself).

https://docs.microsoft.com/en-us/power-bi/desktop-connect-to-web-by-example

Inspired by a conversation with a fellow group member and armed with my new knowledge of the new from web connector, I thought I’d try and connect to the NZ company register to take this feature for a spin.

The result can be found in the Power BI report below.

In a follow up post I will detail how I used the new web connector to get the data, what issues I encountered and what I would do differently next time.