公開時に Location フィールドを使用しますか？

Question

こんにちは、

Power BI で色のシンボル（コロプレスマップ）を使って視覚化したい定量的な郡データがあります。Desktop ではまさに望んでいる通りですが、これはすべて公開データであり、有用にするために web に公開する必要があります。しかし、Location フィールドのデータを使って web に公開することがうまくできません。a) なぜこの制限があるのでしょうか？b) ESRI は近い将来その機能を有効にするためにすでに取り組んでいますか？（アイデアを出すべきでしょうか？）

そして c)、これを実現するための回避策はありますか？点を使って公開することはできますが、塗りつぶされたポリゴンほど強力な視覚化にはなりません。（arcGIS Online アカウントから郡の参照レイヤーを使うこともできますが、定量的データに基づいてそれらを着色する方法はないと思われ、それでは目的が果たせません。）

Jon Emch · Answer

Hey there Kate,

Just wanted to post something here so that folks are aware that there is an existing enhancements in our system to allow non coordinate location fields into the publish to web workflow: ENH-000137246.

I would highly recommend folks log a case with Esri Support to be added to this ENH. Also please update Kate's idea in the PowerBI Ideas board!

Kate447 · Answer

Hi @BenCoubrough ,

Thanks for the reply! I do have a column of County, State for my data, and dragging that into the Location well works wonderfully in Desktop - it is exactly what I need. However, I cannot publish this to web in order to embed it on my website (fails publish to web validation check because it wants Location to be empty).

The documentation states: "Power BI data used to create the ArcGIS for Power BI map must use latitude and longitude coordinates for locations. If the Location field well contains addresses or standard boundaries, publishing to the web will not work." (source)

So I am wondering if there is some other way to achieve the same goal (choropleth map of counties published to web), or at least if someone from ESRI could explain the reasoning to me of why this is allowed in Desktop, but disabled for publishing to web. A dot density map is not as useful of a visualization of this type of data. (Again, it is all publicly available data!) I'd also love to know if ESRI is currently working to enable this for Publish to Web and I should just hang tight a few months.

Thanks!

BenCoubrough · Answer

Hi @Kate447,

I talked about how we can do this in my answer here - How to import GIS data into Power BI

You can use the Location field well to display geospatial data in ArcGIS Power BI, however it requires a little bit of preparation beforehand - ArcGIS Power BI Location Types

* What is the locational data from your quantitative data? Perhaps you could show a screenshot of your attribute table & how it's displayed in ArcGIS Desktop?

Choropleth maps can be really quickly set up if your polygons have a locational attribute such as County or Suburb.

Regards,

Ben