How to show polygon data in Power BI

From Tygron Support wiki
Revision as of 09:38, 14 December 2023 by Frank@tygron.nl (talk | contribs)
Jump to navigation Jump to search

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

Editor → Current Situation (Ribbon tab) → Administrative (Ribbon bar) → Show Neighborhoods (Dropdown)
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)

{{gallery File:WGS_84_CRS_select.JPG|WGS 84 CRS selection File:Export_wgs_84_neighborhoods.JPG|Export panel for neighborhoods File:Icon_Map_app.JPG|Icon Map app page in Power BI app store File:Icon_Map_visual.JPG|Icon Map visual button File:Icon_Map_config.JPG|Icon Map configuration for Neighborhoods File:Icon_Map_Format_Visual_GeoJSON.JPG|Icon Map Format Visual GeoJSON section File:Icon_Map_Visualization.JPG|Icon Map Visualization }}

Notes

  • Icon Maps currently only seem to be able to visualize GeoJSONs exported using the CRS 4326.

How-to's

See also