Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
10 years ago

ArcGIS Maps for Power BI (Preview) Discussion

Since we announced ArcGIS Maps for Power BI (Preview), we've been getting a lot of great questions and positive feedback.   Let's use this thread for a discussion of ArcGIS Maps for Power BI, inclu...
General Comment
DuncanP's avatar
DuncanP
Icon for Advocate II rankAdvocate II
9 years ago

Hi

 

Ok, so here's another issue I've looked into further. There are some non-geographic postcode districts which get mapped to geographic areas. Not necessarily a problem per se, but the way it manifests itself is confusing. In the image below, I've mapped postcode districts and excluded BS29. This shows BS99 (non-geographic) mapped to the BS29 area:

You can see that the colour of the area shows there are significantly more bookings than in the surrounding postcode districts. Now if I remove the filter to show BS29, we get the following:

This now shows the correct postcode district and booking count for that district, but the colour still seems to be driven by the underlying BS99 postcode which is now not visible on the map at all.

 

Obviously now that I know about this, I can go back into my data and mark all the non-geographic postcodes so they can be excluded from mapping, but until I worked this out, I thought there was something seriously wrong with the sizing algorithm! I don't know what a good solution would be from the mapping point of view, but I thought I'd flag this up anyway.

 

Cheers,

 

Duncan

scottball's avatar
scottball
Icon for Helper I rankHelper I
9 years ago

Hi DuncanP, thanks for the great screen shots and write-ups of the issue.

 

We were already aware of the currency formatting issue and are working on a fix. The faulty matching of postcodes without geographies should be handled by our backend, but for some reason it's not being handled correctly. We are investigating what we can do to resolve the issue. Bear with us as we develop and roll out a fix.

  • DuncanP's avatar
    DuncanP
    Icon for Advocate II rankAdvocate II
    9 years ago

    Hi scottball, thanks for looking into this. You're really going to get fed up with me though, as I've now started to notice geographical postcode districts that are incorrectly mapped as well.

     

    so,

     

    TS13 is mapped to BS13

    TS15 is mapped to BS15

    DN55 is mapped to DE55

    DN21 is mapped to BN21

    SY13 is mapped to DY13

    OX17 is mapped to EX17

    SE3 is mapped to SS3

    SE9 is mapped to SS9

    All the IM districts are mapped to CM districts

     

    There are also some minor issues with some of the shape data, for example:

    A part of NR21 has split off and ended up inside PE31

    There is also a small gap between NW1 and N1

    PO22 has been split by BN18

    Part of BS22 is inside BS24

    Part of NE30 is in NE29

    There are quite a few more of the bisected districts, which is understandable given the weird shapes some of them have, so this is probably nit-picking really.

     

    I'm really enjoying using this though, and I'm very impressed by the speed of it, so thank you.

     

    Best,

     

    Duncan

     

     

     

    • scottball's avatar
      scottball
      Icon for Helper I rankHelper I
      9 years ago

      Hey DuncanP - 

       

      No worries. I think it's all related (regarding the mismatches). Our underlying service used to give error codes for unmatched addresses, which client applications could filter out or handle differently at their discretion. Now the backend service attempts to find a match no matter what - resulting in some undesireable matches. We're working with the team responsible for this behavior to get it modified, and then we'll update our code in turn. It won't get fixed overnight, but rest assured we're working on it.

       

      Regarding the bisected districts and weird shapes you might be seeing - in order to keep the speed high, we are 'generalizing' the shapes - that's to say, we're making the shapes a lot simpler than they really are in order to transmit them across the wires quickly. It's a balancing act - we want them to be simple enough that they are fast, but we don't want them so simple that they lose the ability to represent the thing they're supposed to represent. Please let me know if it's erring too much towards the latter and we can take a look at tweaking it a bit. 

       

      I'm really happy to hear that despite some hiccups you're enjoying the visual! 

      • dcresp's avatar
        dcresp
        Icon for Advocate IV rankAdvocate IV
        9 years ago

        We are really keen on this as a mapping tool within Power BI and think it is alreaydy great and has a lot more potenital. The potential for us as large users for Esri products will be being able to login and use our own mapping hosted securely on the Esri server to be able to add into the Esri Power BI map and then share with external users in a secure way. The other key item that we need is to know if this visual will work with Power BI Embeded. scottball are you able to give us any guide as to when we will be able to get to our secured mapping and share that with others. Also I have not seen an answer about if this will work with PBIE.

         

        Thank you for your assistance and please keep working on this great addition to PBI.