How to access your project data in Power BI

From Tygron Support wiki
Revision as of 13:43, 15 November 2023 by Frank@tygron.nl (talk | contribs) (Created page with "Data from projects can be accessed by Project BI using a web connection for the geojson endpoint. {{editor location|geo plugins}} {{howto|title=access your project data in Power BI. | Open any project, and preferable put it on Keep alive. | Choose an item that you want connect to, such as Neighborhoods | Hover over Neighborhoods, and in the popup select Export Geo Data | As the format, select GeoJSON (Convert collections to MultiPolygons) | Click on the...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

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

Editor → Tools (Ribbon tab) → Geo Plugins (Ribbon bar)
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 new data, select web
  9. Paste the link in the url field and select ok.
  10. By default, create a table of all the properties.
  11. Click on the Close and Apply button.
  12. Add a chart type, such as the bar chart.
  13. In the detail panel, identify the x data values field.
  14. In the data panel, unfold the connection item and drag the name field from the list of properties to the x data value field.
  15. Similarly, select the data field you want a bar chart of, such as "AANTAL_INWONERS" and drag this property to the y data value field.
  16. The bar chart should now be created.