cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

UK post codes API from Land Registry data

Hi, I’m new to Power BI and am looking for some guidance...

Does anyone know if it is possible to use the UK post codes API from Land Registry data and filter down into one postcode so it will show a piece of land by this postcode?  I was able to do it by only uploading the National Statistics Postcode Lookup UK file but I need to use the API – can anyone help?

Thanks

2 REPLIES 2
Highlighted
Responsive Resident
Responsive Resident

Re: UK post codes API from Land Registry data

It's hard to tell by looking at your requirements what you are trying to achive. Do include a link to the API that you refer to in the future so that to narrow down the search on which API you refer to. As to the in's and out's of calling an API Chris Webb's blog contains a plethora  of information on this topic https://blog.crossjoin.co.uk/?s=postcode..

 

One point worth mentioning is that although Power BI is feature reach when it comes to accessing various data sources, Although you can make a call to an API to get the right data, you won't be able to initiate this call from the Reporting View. So although you can get all you data you need in Power BI, unless it has already been loaded into the Data Model you won't be able to display it in any of the views. A solution that I find feasible in this case is to load some of the data in Power BI, say all of the postcodes, and then build the right URL inside your Data Model for accessing the mapped poligons so that in the Report View you can navigate to the right data via clicking through to a browser page. 

Highlighted
Frequent Visitor

Re: UK post codes API from Land Registry data

Hi,

Thanks a lot for the reply, i will have a look to the blog and try to use URL in Data Model.

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Find your favorite faces from the community presenting at the Power Platform Community Conference!

Upcoming Events

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors
Top Kudoed Authors