How to access your project data in Power BI

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

Data from projects can be accessed by Power BI using a web connection for the GeoJSON endpoint.

Editor → Current Situation (Ribbon tab) → Administrative (Ribbon bar) → Show Neighborhoods (Dropdown)
How to access your project data in Power BI.:
  1. Open any project, and preferable put it on Keep alive.
  2. Choose an item that you want connect to, such as Neighborhoods
  3. Hover over Neighborhoods, and in the popup select Export Geo data
  4. As the format, select GeoJSON (Convert collections to MultiPolygons)
  5. Click on the second Copy URL button, next to Online GeoJSON Endpoint.
  6. Open the Power BI Desktop application
  7. Create a new project or open an existing one.
  8. Under add Get Data, select Web
  9. Paste the link in the url field and select ok.
  10. A new panel opens, and by default, a table is created of all the properties.
  11. Click on the Close and Apply button.
  12. In the Visualization panel, select the second option named Stacked column chart.
  13. A preview should be added to your page section, indicating you need to drag or select a field.
  14. In the Visualization panel, identify the X-Axis data field.
  15. In the Data panel, unfold the connection and drag the name field from the list of properties to the X-Axis data field.
  16. Next, select a value property, such as AANTAL_INWONERS and drag this property to the Y-Axis data field.
  17. The bar chart should now be created.

Notes

  • Use the search bar in Power BI to filter data fields.

See also