View source for How to access your project data in Power BI

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

<youtube>au_d4iusBvI</youtube>

{{editor location|neighborhoods}}
{{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 [[Neighborhood]]s.
| Hover over Neighborhoods, and in the popup select [[Export Geo data]].
| As the format, select GeoJSON (Convert collections to MultiPolygons).
| Click on the '''second''' Copy URL button, next to '''Online GeoJSON Endpoint'''.
| Open the Power BI Desktop application.
| Create a new project or open an existing one.
| Under add '''Get Data''', select '''Web'''.
| Paste the link in the url field and select ''Ok''.
| In the Access Web content step, choose the default option and select ''Connect''.
| A new panel opens, and by default, a table is created of all the properties.
| Click on the Close and Apply button.
| In the ''Visualization'' panel, select the second option named ''Stacked column chart''.
| A preview should be added to your page section, indicating you need to drag or select a field.
| In the ''Visualization'' panel, identify the '''X-Axis''' data field.
| In the ''Data'' panel, unfold the connection and drag the name field from the list of properties to the '''X-Axis''' data field.
| Next, select a value property, such as ''AANTAL_INWONERS'' and drag this property to the '''Y-Axis''' data field.
| The bar chart should now be created.
}}
<gallery>
File:PowerBI_Export_GeoJSON.png|Copy URL for "Neighborhoods as GeoJSON"-endpoint.
File:PowerBI_Web_connection.png|Paste the URL and create a web connection.
File:PowerBI_Anonymous_connection.png|Choose anonymous connection.
File:PowerBI_web_connection_table.png|Created table for the GeoJSON web connection.
File:PowerBI_Close_And_Apply.png|Close and apply.
File:PowerBI_Empty_Bar_Chart.png|Vertical bar chart selected from the Visuals.
File:PowerBI_Bar_Chart.png|Stacked column chart with neighborhood name and number of inhabitants.
</gallery>
{{article end
|howtos=
* [[How to show Indicator results in Power BI]]
* [[How to show Overlays in Power BI]]
* [[How to show polygon data in Power BI]]
|notes=
* Use the search bar in Power BI to filter data fields.
|seealso=
* [[Power BI]]
}}
[[Category:How-to's]]