Latest Contributions by JoshJones2

Hey Mark, The layout I proposed above fits with what you describe - dynamic drilling locations (data sources from PowerBI) and static branch location data (data sources from your ArcGIS Online layer) as long as you're okay with the branches being represented as polygons similar to what I described above. The use case that I pasted a picture from above was showing store stock overlain with polygons representing distribution center territories - not exactly the same, but a similar type of use case. To answer your second question, no, you don't necessarily need to have an ArcGIS Online subscription for all of your viewers as long as you are willing to publish the reference layer (i.e. the branch location polygons, not the dynamic drilling location data) publicly. If you want those polygons shared only privately, that does require each person to sign into an ArcGIS Online account. Hope this makes sense, but if not of course feel free to ask any additional questions! Josh ... View more

Hey Øystein, First up, here's a fixed version of the link Anthony provided that will be accessible externally: Change the symbol style—ArcGIS Maps for Power BI | ArcGIS  I'd like to get some perspective on what you mean by "proportional" in this context. My guess is this - the points are scaling based on the image that you pasted above, but a point that has a value of "100" is not 100 times larger than a point that has a value of "1". Is that what you mean? In case what I've written above is an accurate representation of the issue, I'm going to tag in Alagiri Venkatachalto this post as well so that he can comment on the way that scaling is handled for points, since I don't know if there is an option to scale them at exactly relative sizes. Josh ... View more

Here's the doc Alagiri's referring to: Clear browser local storage—ArcGIS Maps for Power BI | ArcGIS  ... View more

Hey Mark, Just wanted to add a little extra detail to Anthony's response above. If all of your data is lat-long based, you should be able to directly consume that as points by pushing that data into Power BI itself, then dropping it into the latitude longitude field wells on the ArcGIS Maps for Power BI visual. Sounds like you might already be doing that part. My belief is that you then want to put another layer on the map to show your branches in relation to the location of the drilling activity. The best way to do this would probably be to create polygons indicating the boundaries of those branches by using a custom reference layer. You can create this with an ArcGIS Online subscription, publish it as a Feature service, then consume it back in ArcGIS Maps for Power BI. The end result would look something like this, with a set of polygons representing boundaries for each branch, and activity represented by points (or a heat map if that makes more sense): If you'd like, I can put you in touch with the sales team who should be able to set you up with a trial. Josh ... View more

Hi Steven, Sorry for the delayed reply. I wanted to touch on your question and address a few points. Not sure if I can give you a complete answer given the information above, but I can at least start: What I want to do is include a point reference layer with a boundary layer... Typically in ArcGIS Maps for Power BI, the points that you bring in would be based on the data that is coming from Power BI itself, and the boundary layer (polygons) would be a reference layer that you add in, as you would normally drive selection of points (and thus cross filter other visuals) by the reference layer's polygons. This work flow wouldn't work if your reference layer was constructed of points, since the selection would only be driven by those points from your data that were exactly coincident with the reference layer points. Since this isn't making sense to me, there's a good chance here that I'm not understanding your use case. Would you mind walking me through how you would use the point layer as a reference layer? I'd like to understand and see if that's something we should explore in the product. ... does a paid for online subscription actually allow me to share layers to Power BI ... Yes, if you have an ArcGIS Online subscription, you can author your own custom feature services with a single layer and then consume those feature services back in ArcGIS Maps for Power BI. As an additional point here... ... share the file publicly (which I don't understand why it has to be public) ... The requirement to share your layer publicly is only the case if you do not have a private ArcGIS Online organization. As long as you're signed into your ArcGIS Online account in Maps for Power BI, your layers can be privately shared within your organization. Layers must be shared publicly if you aren't signed in since there is otherwise no way to reach those layers. ... another idea for future upgrades is to allow the visual to be used in the embed and publish to web functions. We're currently exploring this, as we've had this request from a number of people. ... my first tests indicate issues such as place and point labels aren't coming through. Feature services do need to be restricted to a single layer in order to be consumed in ArcGIS Maps for Power BI. If you want to share a cop[y of the service that you're working with (or a representative example), I'd be happy to take a look and see if there's some reason that your labels aren't showing up. Thanks, Josh ... View more

Hey Nicholas, My name is Josh Jones, I'm the Lead Product Engineer on ArcGIS Maps for Power BI. This looks like it might be a use case we hadn't considered! I'll get a member of my team to take a look and see if this is something we can fix. Josh ... View more

Hi Edward, My name is Josh, and I'm the Lead Product Engineer for Esri's Microsoft integration products. We recently raised the ceiling to 30,000 points, as long as those points are already lat/longs. Based on the numbers you gave above, I'm going to assume that you are working with addresses (or another data type that has to be converted from a string to a location or "geocoded"). If that's the case then yes, the limit is considerably lower (1,500) for free users of the visual. Since you mention "Pro" access, I'm assuming that you're referring to PowerBI Pro, and I should point out that this is a separate product from a "Plus subscription" to ArcGIS Maps for Power BI (or signing in with an ArcGIS Online account). Purchasing Pro access from Microsoft does not include a subscription to Plus from Esri. Details on the Plus subscription can be found here: About Plus—ArcGIS Maps for Power BI | ArcGIS  When signed in to the visual with a Plus account (or an ArcGIS Online account) the limit on geocodes is raised to 5,000. Again, however if you separately geocode your addresses then bring them into the report, you can have up to 30,000 points on the map. The location to sign in on the visual can be found in the top right corner of the visual, and it looks like this: Hope this helps, Josh ... View more

It depends on your use case specifically and what you're looking to accomplish - Insights for ArcGIS is also an option if you're more heavily leaning toward the BI piece. It would probably be a good idea to have a chat with your Esri account manager to see if they can go through the options in detail with you. ... View more

Hi Peter, Thanks for reaching out! I definitely understand the desire for this. At present, this is not currently on the road map for this product for 2019. We will however keep it in mind for the future. Thanks, Josh ... View more

Hi Muhammad, Thanks for reaching out. I'm the Lead Product Engineer for Microsoft Integration products here at Esri, and I wanted to get in touch to respond. We're very interested in figuring out performance issues, and this is one of our biggest focuses for 2019 - we are intending to switch some things around to drastically improve performance. That said, I'd like to make sure we're working from the same starting point. I loaded up your pbix on my computer here to check out the performance, and here's what it looks like when I'm panning and zooming around: If what you're seeing is worse than this, let me know. Part of the reason that this is loading fairly slowly is because of the sheer number of polygons on the map, particularly when showing the entirety of Canada. There is a limited amount that you're going to be able to do from your end to make this better (unless you split your data into subsets which only contain segments of the country), but we are working on mitigating this in the near future.  Josh ... View more

I'm not seeing an image attached to the post - not sure what happened there. That said, I suspect that this layer might help answer your question: http://www.arcgis.com/home/item.html?id=81d23ced573b4666bd0004c93fd9edfc  This will show the boundaries on a map to see what each one looks like and shows statistical areas 1 - 4. For more fine grained definitions of the boundaries, the ABS has the best data: Australian Statistical Geography Standard (ASGS)  I'm going to also tag Lucy Guerra‌ and Chris Wilcox in this thread so that they can see it, to avoid me relaying things back and forth, or tag others as appropriate. ... View more

Thanks for the reminder - I didn't hear back from the content team. I'll reach out again today. The only info I got so far is that the boundaries are based on the 2016 Australia data from MB Research (Michael Bauer Research GmbH), released in June 2017. In turn, this is based on data from the Australian government collected in 2012. I'm asking to see if I can get more documentation surrounding the boundaries. ... View more

Got it - thanks for the clarification! I'm working with the content team right now to try to get an answer to what you're asking here, or at least some doc on it to provide guidance. ... View more