Display lines for Azure map in Power BI

Question

I am a newbie to power bi.  I need to display lines using the Azure map format in Power BI.  Is there a good instruction place for me to go and follow steps?  I have a geojson/json/shp files that I tried messing around with but couldn't see how lines could be created.  What is best practice?

fshih · Answer

I have a similar need.  My data is coming from Microsoft Fabric.  I would create the Esri JSON using ArcGIS GeoAnalytic Engine for Microsoft Fabric and write the data into a table in LakeHouse.  However, the semantic model (for bringing data into PowerBI from Fabric) will fail to load or refresh when I add the Esri JSON field.  Is there a way to get this working?

NaZhang_Esri · Answer

Hi @EricS ,

Thanks very much for your question! Good try on mapping these data! We support EsriJSON for mapping lines data. In the future, geojson will be supported but not for now. SHP file cannot be directly uploaded in ArcGIS for Power BI. I'm not sure where your SHP file is from. But if you are an ArcGIS users, you can directly add layers from ArcGIS by sign in to ArcGIS for Power BI.

Here's a storymap that shows how to map the location/geometry data with words and some short videos.

https://storymaps.arcgis.com/stories/dc0c7f9ab73c469aaea407213d0883a1#ref-n-1PVr17

If you want to learn more about ArcGIS for Power BI, please feel free to check out our documentation.

https://doc.arcgis.com/en/microsoft-365/latest/power-bi/get-started-with-arcgis-for-power-bi.htm

Please feel free to let us know if you have any other questions! 😊