https://community.esri.com/t5/arcgis-online-questions/conduct-a-spatial-join-with-data-amp-esri-map-in/m-p/1283656#M51779 <P>Hi,</P><P>This question has to do with the collaboration of Esri and Power BI through AGOL.&nbsp; 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&nbsp;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, then use the aggregated values of those features as a measure to display in a bar chart, or use the features to filter other visuals?</P><P>Tableau has the ability to conduct a spatial join with 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?</P><P>Thank you!</P><P>&nbsp;</P><P>Ashley</P><P>&nbsp;</P> Thu, 27 Apr 2023 23:50:27 GMT ClackamasCrime_Analysis 2023-04-27T23:50:27Z https://community.esri.com/t5/arcgis-online-questions/conduct-a-spatial-join-with-data-amp-esri-map-in/m-p/1283656#M51779 <P>Hi,</P><P>This question has to do with the collaboration of Esri and Power BI through AGOL.&nbsp; 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&nbsp;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, then use the aggregated values of those features as a measure to display in a bar chart, or use the features to filter other visuals?</P><P>Tableau has the ability to conduct a spatial join with 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?</P><P>Thank you!</P><P>&nbsp;</P><P>Ashley</P><P>&nbsp;</P> Thu, 27 Apr 2023 23:50:27 GMT https://community.esri.com/t5/arcgis-online-questions/conduct-a-spatial-join-with-data-amp-esri-map-in/m-p/1283656#M51779 ClackamasCrime_Analysis 2023-04-27T23:50:27Z