Skip to content
January 14, 2014 / Erik Svensen

Using Power BI to enrich your data using public datasets – part 1

Yesterday I presented at a LinkedIn group – Microsoft BI Professionals Denmark a session about how you can use Power Query to enrich your datamodels using public datasets.

My demo contained examples on how to use the API from Statistics Denmark link – to extract all sorts of information about Denmark directly into your datamodel and how you can use the public dataservice http://geo.oiorest.dk/ to do a reverse look up of Danish regions, municipalities from a specific lat/long coordinate.

You can download my demo files from here.

The presentation – Link

The Excel file – Link

I will create a Part 2 of this post where I will go through the steps of getting the data from Statistics Denmark into your model.

Advertisements

4 Comments

Leave a Comment
  1. Lorents Nord-Varhaug / Jan 14 2014 2:21 pm

    Tak for et rigtig godt indlæg i går! Cool at se de mere avancerede måder at konvertere data fra danske datakilder!

  2. Lorents Nord-Varhaug / Jan 14 2014 9:08 pm

    Hentet din Excel-fil, og fik en fejl i ‘Kommune’-kollonen. Jeg tilføjet en ‘/’ forran kommune i FILTERXML kommandoen, og det hjalp:

    =FILTERXML(WEBSERVICE(Start&SUBSTITUTE([@Lat];”,”;”.”)&”,”&SUBSTITUTE([@Long];”,”;”.”));”//kommune/navn”)

    (oprindelig var der “/kommune/navn”)

    • Erik Svensen / Jan 15 2014 4:00 pm

      Hi,

      I can make it work both with one and two // – but I do experience #Value error sometimes but an autofilter on those values – makes it look up again and the problem is solved.

      Erik

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: