How to show polygon data in Power BI

'"`UNIQ--youtube-00000000-QINU`"'

Editor → Current Situation (Ribbon tab) → Overlays (Ribbon bar)

How to show polygon data in Power BI:

1. Open or create a Power BI project that has a web connection to Neighborhoods of a project session. See this How-to;
2. Select the visuals tab in your Power BI Project
3. Click on the triple dots icon named "Get More Visuals" and select the option "Get More Visuals".
4. In the search field, type "Icon" and select the "Icon Maps" app.
5. On the Icon Map app page, click on the "Add" button.
6. Unfold the "Neighborhoods" data connection
7. Find and drag the features.properties.NAME attribute to the Category field.
8. Select a numerical property, such as feature.properties.ACTIVE and drag it to the Size field.
9. The Icon Map should now show a map, but not yet the shapes of the neighborhoods.
10. Select the "Format your visual" tab and unfold the GeoJSON section.
11. Click on the Off button to activate it.
12. Switch to the Tygron Client Application to a Neighborhood GeoJSON endpoint.
13. Select Current Situation in the Ribbon bar
14. Hover over Administrative and under Neighborhoods, select Export Geo data.
15. In the Export Geo Data panel, set the type to GeoJSON (MultiPolygons).
16. Verify that the export CRS is set to 4326. If not, click on the edit link.
17. In the CRS selection panel, type 4326 and press enter.
18. Wait for the process to finish and select the WGS84 CRS with the number 4326 and confirm with select.
19. Click on the Copy URL button next to GeoJSON endpoint.
20. Switch back to Power BI and paste the link in the URL field in the GeoJSON we had previously activated. (Use CTRL-V)

Notes

• Instead of an Overlay ID number, you can also use the WMS background layers.
• To access a different timeframe for an Overlay, type the Overlay ID followed by a dash and then the timeframe number. For example: 14-3, 10-0 or 3-99.

How-to's

• How to access your project data in Power BI

See also

• Power BI
• WMS