I need to SPATIALLY JOIN my data set with my very specifically featured map coming from AGOL.

[ClackamasAshley]

Hi,

This question has to do with the collaboration of Esri and Power BI through AGOL.  Once we bring in an AGOL map into a Power BI dashboard through the "ArcMaps for Power BI" visualization, is there then a way to conduct a spatial join with our existing point data that is streaming in from a SQL Server source that has a lat and long so I can "bucket" the points into their respective intersecting map features?

I'm getting a lot of feedback in online searches to just use the "Join layer" field in the AGOL visual to join my map layer and my data together, but I need to conduct a SPATIAL JOIN, and not just a regular data join because my data that is streaming in does NOT include a field containing my map's attributes for them to join with. I need the join to literally tell which map feature each set of coordinates needs to be assigned to by intersecting my data with my map.

Tableau has the ability to conduct a spatial join with my SQL server connected data by way of a MAKEPOINT calculation using the lat and long of each data point intersect with features in a shapefile. Is there any hope of anything in Power BI that possibly has that kind of capability, and if so, how can I make it happen?

Thank you!

Ashley

[rajendraongole1]

Hi @ClackamasAshley  - Yes! While Power BI's ArcGIS for Power BI visualization does not directly support spatial joins like Tableau's MAKEPOINT, there are workarounds to achieve the same result.

Publish Your Point Data to AGOL

If your SQL Server data is static or can be updated periodically, you can upload it to ArcGIS Online as a hosted feature layer.
Use ArcGIS Online’s "Analysis Tools" → "Spatial Join" to assign each point to the corresponding map feature.
Bring the joined dataset into Power BI using the ArcGIS for Power BI visual.
Automate the Process (If Data is Changing Frequently)

Set up a spatial join automation via ArcGIS Pro or ArcGIS Online's Python API to update the dataset before Power BI ingests it.

Hope this helps.