Does the "Location" well support the esri geometry strings?

348
2
10-24-2023 09:43 PM
Labels (2)
MichalGasparovic
New Contributor III

Hi,

previously the "Location" well supported both the string for geolocation or the esri formatted geometry string, e.g. "{x:684194.7751, y:7373432.7, spatialReference: { wkid: 20255 }}"

Currently this is not working anymore?! Can you please provide some directions here, thank you

Tags (1)
0 Kudos
2 Replies
MichalGasparovic
New Contributor III

according this article it should support it: 
Data preparation—ArcGIS for Microsoft 365 | Documentation

 

It used to work just fine some time ago, now when I'm to provide the report with the map I can't use it as it doesn't appear to be working. it appears to set the extent of the map correctly after i add the column containing the geometry formatted as esriJSON, but no symbology appears, it neither zooms to the feature when selecting in the other table visual. 

Is there anything else needed in the esriJSON formatted string that I've provided above?

0 Kudos
NaZhang_Esri
Esri Contributor

@MichalGasparovic ,

 

Thanks for your question! ArcGIS for Power BI supports Esri JSON data format that is added  to the Location field well. The format is restricted. Seemed like  "{x:684194.7751, y:7373432.7, spatialReference: { wkid: 20255 }}" is not the correct format.

List an example here.

{"paths":[[[-10834xxx.1138,3233xxx.7973],[-10840xxx.2779,3228xxx.8609],[-108414xx.9759,3226926.9777],[-108414xx.0852,3226353.7],[-10842xxx.8925,3224633.8668],[-108421xx.9092,3223xxx.0595],[-10842xxx.4638,322xxx.5041],[-108xxx51.6173,3222536.6259],[-10xxx1xx.6782,3xxx652.8227],[-10842xxx.9492,322xxx.1105],[-10xxx72.468,3220948.1689],[-10842681.5755,32xxx0.3957],[-10842xxx.2878,3222xxx.8611],[-108xxx870.2795,3222866.2605],[-10842xxx.5021,3223348.7693],[-10842xxx.4638,3223xxx.1054]]],"spatialReference":{"wkid":102100,"latestWkid":3857}}

 

You could use ArcGIS for Power Automate connectors to get the correct format. https://community.esri.com/t5/arcgis-for-power-automate-blog/using-arcgis-connectors-for-power-autom...

0 Kudos