https://community.esri.com/t5/arcgis-for-power-bi-ideas/join-non-spatial-data-in-power-bi-to-spatial/idi-p/1037949 <P>In our example, our users have a polygon reference layer of well areas in ArcGIS Online. In Power BI, they have a non-spatial dataset which contains info about well locations. They would like to be able to join this non-spatial dataset to the reference dataset and then publish the results. This isn’t currently possible as to publish a Power BI report with a map to the web, any datasets coming from power BI must have XY data attached. (<A href="https://gbr01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fdoc.arcgis.com%2Fen%2Fpower-bi%2Fdesign%2Fpublish-to-web.htm&amp;data=04%7C01%7CPatrick.Rickles%40ogauthority.co.uk%7C4f04435a69244dc1848c08d8e3e1d6fd%7Ce681c59d868e488780face36f1f21b0f%7C0%7C0%7C637509906403562134%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&amp;sdata=4lk45N2LBteJzQl0B0ozRXT4O4CIQ9GUJMetZOf9OXo%3D&amp;reserved=0" target="_blank">https://doc.arcgis.com/en/power-bi/design/publish-to-web.htm</A>)</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Rickles_OGA_0-1616063493489.jpeg" style="width: 400px;"><img src="https://community.esri.com/t5/image/serverpage/image-id/8751i02723172341D4603/image-size/medium?v=v2&amp;px=400" role="button" title="Rickles_OGA_0-1616063493489.jpeg" alt="Rickles_OGA_0-1616063493489.jpeg" /></span></P><P>&nbsp;</P><P>Currently, the users are working around this by adding XY data to their well locations dataset and simply making that layer completely transparent on the map. However, they feel the there would be a huge benefit to being able to join non-spatial datasets to spatial datasets and publish the results.</P> Thu, 18 Mar 2021 10:31:47 GMT Rickles_OGA 2021-03-18T10:31:47Z https://community.esri.com/t5/arcgis-for-power-bi-ideas/join-non-spatial-data-in-power-bi-to-spatial/idi-p/1037949 <P>In our example, our users have a polygon reference layer of well areas in ArcGIS Online. In Power BI, they have a non-spatial dataset which contains info about well locations. They would like to be able to join this non-spatial dataset to the reference dataset and then publish the results. This isn’t currently possible as to publish a Power BI report with a map to the web, any datasets coming from power BI must have XY data attached. (<A href="https://gbr01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fdoc.arcgis.com%2Fen%2Fpower-bi%2Fdesign%2Fpublish-to-web.htm&amp;data=04%7C01%7CPatrick.Rickles%40ogauthority.co.uk%7C4f04435a69244dc1848c08d8e3e1d6fd%7Ce681c59d868e488780face36f1f21b0f%7C0%7C0%7C637509906403562134%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&amp;sdata=4lk45N2LBteJzQl0B0ozRXT4O4CIQ9GUJMetZOf9OXo%3D&amp;reserved=0" target="_blank">https://doc.arcgis.com/en/power-bi/design/publish-to-web.htm</A>)</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Rickles_OGA_0-1616063493489.jpeg" style="width: 400px;"><img src="https://community.esri.com/t5/image/serverpage/image-id/8751i02723172341D4603/image-size/medium?v=v2&amp;px=400" role="button" title="Rickles_OGA_0-1616063493489.jpeg" alt="Rickles_OGA_0-1616063493489.jpeg" /></span></P><P>&nbsp;</P><P>Currently, the users are working around this by adding XY data to their well locations dataset and simply making that layer completely transparent on the map. However, they feel the there would be a huge benefit to being able to join non-spatial datasets to spatial datasets and publish the results.</P> Thu, 18 Mar 2021 10:31:47 GMT https://community.esri.com/t5/arcgis-for-power-bi-ideas/join-non-spatial-data-in-power-bi-to-spatial/idi-p/1037949 Rickles_OGA 2021-03-18T10:31:47Z https://community.esri.com/t5/arcgis-for-power-bi-ideas/join-non-spatial-data-in-power-bi-to-spatial/idc-p/1197048#M173 <P>I agree with this.&nbsp; One our use cases is for our administrative boundary polygons.&nbsp; We have them stored in our Portal as a feature service.&nbsp; Since Power BI doesn't support geometry data types, we would like to bring them as a reference layer in Power BI and the join the non-spatial data Power BI data to it.&nbsp; This way we could symbolize the polygons based off data used in the rest of the reports.&nbsp; If cross filtering was enable too, it would be awesome.</P> Thu, 28 Jul 2022 19:44:00 GMT https://community.esri.com/t5/arcgis-for-power-bi-ideas/join-non-spatial-data-in-power-bi-to-spatial/idc-p/1197048#M173 KevinDunlop 2022-07-28T19:44:00Z