Latest Contributions by AW_Grove

I'm still seeing this issue too. ... View more

Thanks. We will look into this option. It would be much more beneficial to see out of the box so we don't have to maintain another process, but this may work as a short term alternative.  ... View more

Thanks @JeffSilberberg  - in your experience is this something that would eat up tons of credits since it would run every 3 or so minutes against hundreds of records and I assume update a copy service each time (which would be slightly delayed from the Velocity layer) that we would feed into other applications?  ... View more

This update would make the solution actually useable for our Operations folks. Right now, if the driver doesn't use their keyfob we can only provide our dispatch center with vehicle location and they will see the entire fleet at once. That means dispatch knows a vehicle is nearby, but they have no way of knowing which team that vehicle is a part of (customer service, treatment, wastewater, locates, etc.). This means they don't know who or how to contact the individual or whether that vehicle is likely to have the equipment/skillset be able to address the issue. If the vehicle group is provided to Velocity we can then: - query the data to only show customer service vehicles in the customer service application - show the dispatch center everyone and allow them to filter to the 'T&D Construction' vehicle group when there is a water break - show the dispatch center everyone and allow them to see what team is closet to a call and then use that team's radio channel to ask them to complete a site check Thanks for this suggestion! ... View more

Hi @SeanKMcGinnis  - We also had big problems with taking maps offline in Field Maps last week after the AGOL upgrade. I think this was related since I made no changes and everything was resolved Monday morning.  ... View more

@SeanKMcGinnis  - Hi Sean, we have been using this successfully for almost 2 weeks and then the AGOL update seems to have broken our process (or maybe something else, just coincidence in timing) . We are now seeing errors like below, even though the data size hasn't changed from last week. Any ideas of what is going on? The issue started on 2/22 as far as I can see from our failure logs.    ... View more

Thanks @SeanKMcGinnis ! And I feel ya @TimMinter - it would be great if there was an easier way to get the data securely.   @SeanKMcGinnis - if you have a feature class over 60k records, is it best practice to query your dataset in AGOL to not exceed the Power Automate and then combine the data on the backside through a dataflow in Power BI? Or is there a way to start the 'Do Until' Loop again to go through until you have all 100k, 500k, 1M, etc. records?   ********** Update ********  I don't know how I missed this, or what the limits are, but you can change how many times Power Automate does the 'Do Until' loop. I have it on 1000 and its working (but my feature class only has 70k records). The default is 60 loops.      ... View more

Thank you for this solution @IsmaelChivite . Is there any way that ESRI can give us a heads up of significant changes like this through a blog post before or right after updates? Luckily we were able to resolve this thanks to your help on a non-critical workflow but it could have been a big deal otherwise.  ... View more

Does anyone have best practices of where to store the csv exports for use in Power BI? I want to stay away from OneDrive since that is tied to a person. SharePoint seems the best place, but was curious if anyone found a better option. ... View more

Hi @DiegoLlamasOlivares  -  I have been successful following this method for unsecure services: https://resource.esriuk.com/blog/how-to-use-arcgis-with-power-bi/ And this method for secured services: https://community.esri.com/t5/arcgis-online-questions/using-excel-to-access-arcgis-online-automated/td-p/486804 The second option so far has been limited to Power BI desktop instead of a data flow - so I am really interested if you find out a better way to do this.  ... View more

Hi @Song_Li and @ZoltanKelly  - how did you get Power BI to recognize the token at the end of the url? When I look at the token table it has generated, but I am still getting an error that credentials are required.   Thanks!     ... View more

Hi @Jay_Gregory  - I am working on the same thing. We don't even care about the map component, just using the underlying data. This article is really good at stepping you through the process - https://resource.esriuk.com/blog/how-to-use-arcgis-with-power-bi/  Though I have come across several issues so far including date/time formatting, how to pass credentials for secured data, and having to publish services that allow for over 2000 records to be queried at once. If you have found a better way please let me know! ... View more

Thank you for your help. I think it must be related to the JSON query since even the ESRI generated dates (all the same here since I overwrote the service) are wonky.    ... View more

@RodPBI  - do you typically use a JSON query when importing data to PowerBI? Maybe that is where the date issue is stemming from. ... View more