Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Shape map issues topoJSON - Local authority UK

Hi,   I'm trying to create a shape map in Power BI desktop for Local Authority areas in the UK, i've followed these steps: https://docs.microsoft.com/en-us/power-bi/visuals/desktop-shape-map   I'...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Thanks,

 

I've taken a look at those however I am still having the same problems. 

 

I think the problem is the shape files/topoJSON files themselves. I can't find anywhere the most recent local authority data for the UK that doesn't cause the same line problems on the map as above! 

If anyone knows where this might be downloadable that would be great? I'm going to try to learn to use QGIS in the meantime!

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Just to update:

 

I've created the JSON file that I need to add to Power BI but when i follow the steps and go to '+Add map' and select the file, it doesn't add the areas; it doesn't actually do anything to the visual. 

  • C5_Evans's avatar
    C5_Evans
    Frequent Visitor
    6 years ago

    Hi Tanya - did you ever find an answer to this issue? I'm currently experiencing the same thing with MSOA data. Looks fine on MapShaper but then goes a little haywire in Power BI.

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi,

       

      Unfortunately I havent found a solution yet. 

      I'm going to try re-make the shape file in our QGis software but I haven't had chance to do it yet! 
      I'm hoping that in a future update Power BI is better at using these maps as they currently work in Tableau! 

      • C5_Evans's avatar
        C5_Evans
        Frequent Visitor
        6 years ago

        Hi Tanya - thanks for getting back to me. I spent some more time googling and googling and eventually found a solution that worked for me - as you mention, it uses QGIS to change the map projection into a format that works for Power BI shape maps.
        Link: https://dataveld.com/2016/09/01/overcoming-potential-power-bi-shape-map-rendering-issues/

         

        It's from 2016 so some of the QGIS references are a little out of date - but even a QGIS novice like me managed to work it out!

        Good luck with yours.

        Chris