Wie man eine Shapefile-Polygon in Power BI importiert und auf der Karte in BI anzeigt

Question

Hallo,

ich versuche gerade, ein Shapefile-Polygon in BI zu importieren und anzuzeigen,
konnte bisher aber keinen Weg finden.

Was ich versucht habe:
1) Shapefile-Polygon in TopoJSON konvertiert
2) "Shape Map" in Power BI verwendet
   - zufällige Datei für die Eingabe "Location" im Feld-Tab ausgewählt (ich habe einfach eine Lat-Long-Tabelle verwendet),
   - TopoJSON-Datei für die Eingabe "Shape" im Format-Tab ausgewählt
...aber es hat nicht funktioniert...

Ich hatte erwartet, dass die Polygone auf einer Bubble Map in BI angezeigt werden.

Ich wäre dankbar, wenn Sie mir mitteilen könnten, wie ich das realisieren kann.

Danke,
Yshg

GgotbyeolOh · Answer

Hi, Can I get more understanding, what is the meaning of this?

> Then based on a common attribute/field value you can join the business data to you geometry. You cannot style the data based on the joined data, so you will want to style the geometry layer before you add it to Power BI.

I'd like to show business data based on polygon layer (EV share by district), but zipcode location field in PowerBI Arcgis map seems not working. If I set the location, it goes well with it, but if I set a district and boundaries, it shows the wrong location. I can make the result that I want in ArcGIS online, but location type setting and boundaries are not working for me.

I have a several set of base data consisted of zipcodes, shapes, zipkey, city/district   (zipkey is a group of zipcodes to represent 'exact district'.)

ZIpcode data from ArgGIS online.PNG

Picture1.png

ideal result.png

Anonymous User · Answer

From your Desktop GIS of choice, you should be able to export the data as a CSV, which can be used in Power BI if you have POINT data. Power BI does not support other geometries at this time. If you wanted to use polygons, you can separate the business data from the shape data, publish the shape data to ArcGIS Online and add that feature layer to Power BI. Then based on a common attribute/field value you can join the business data to you geometry.

You cannot style the data based on the joined data, so you will want to style the geometry layer before you add it to Power BI.

Hope that helps,

Andrew

Yshg1990 · Answer

JonEmch-san, BenCoubrough-san,

Thank you so much. I much appreciate your kind instruction.

As your instruction, I tried to look into .dbf file, but found that the format is just the series of 0...
The map I'm working on is about 1km×1km with no buildings.
Bubbles are corresponding to the amount of water production...hot spring field. 
(It seems too small to define physical addresses of my polygon)

Then, I am wondering how to extract table that suits BI format in ArcMap.

Thanks again,
Yshg1990