Can I Conduct a SPATIAL JOIN in PBI like I can in Tableau??

[ClackamasCrime_Analysis]

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

[AlagiriVenkatachal]

Hello @ClackamasCrime_Analysis -

This is possible though there are limits on how much dataset you can spatially intersect or select.  

If you have your ArcGIS Map layer as a reference layer and your SQL server X/Y dataset as a Power BI dataset layer, you could indirectly select locations on your Power BI Dataset layer using shapes / boundaries from the ArcGIS Map layers using the "Selection tools".

In the below report, I am selecting locations of customers overlayed on U.S Counties layer in the Map which in turns filters other visuals on the report.