How to access your project data in Power BI: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
(17 intermediate revisions by 3 users not shown) | |||
Line 1: | Line 1: | ||
Data from projects can be accessed by [[Power BI]] using a web connection for the [[GeoJSON]] endpoint. | Data from projects can be accessed by [[Power BI]] Desktop using a web connection for the [[GeoJSON]] endpoint. | ||
{{editor location| | <youtube>au_d4iusBvI</youtube> | ||
{{howto|title=access your project data in Power BI | |||
{{editor location|neighborhoods}} | |||
{{howto|title=access your project data in Power BI | |||
| Open any project, and preferable put it on [[Keep alive]]. | | Open any project, and preferable put it on [[Keep alive]]. | ||
| Choose an item that you want connect to, such as [[Neighborhood]]s | | Choose an item that you want connect to, such as [[Neighborhood]]s. | ||
| Hover over Neighborhoods, and in the popup select [[Export Geo data]] | | Hover over Neighborhoods, and in the popup select [[Export Geo data]]. | ||
| As the format, select GeoJSON (Convert collections to MultiPolygons) | | As the format, select GeoJSON (Convert collections to MultiPolygons). | ||
| Click on the '''second''' Copy URL button, next to '''Online GeoJSON Endpoint'''. | | Click on the '''second''' Copy URL button, next to '''Online GeoJSON Endpoint'''. | ||
| Open the Power BI Desktop application | | Open the Power BI Desktop application. | ||
| Create a new project or open an existing one. | | Create a new project or open an existing one. | ||
| Under add '''Get Data''', select '''Web''' | | Under add '''Get Data''', select '''Web'''. | ||
| Paste the link in the url field and select | | 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. | | Click on the Close and Apply button. | ||
| | | In the ''Visualization'' panel, select the second option named ''Stacked column chart''. | ||
| In the | | A preview should be added to your page section, indicating you need to drag or select a field. | ||
| In the | | 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. | | The bar chart should now be created. | ||
}} | }} | ||
Line 24: | Line 28: | ||
File:PowerBI_Web_connection.png|Paste the URL and create a web connection. | File:PowerBI_Web_connection.png|Paste the URL and create a web connection. | ||
File:PowerBI_Anonymous_connection.png|Choose anonymous connection. | File:PowerBI_Anonymous_connection.png|Choose anonymous connection. | ||
File: | File:PowerBI_web_connection_table.png|Created table for the GeoJSON web connection. | ||
File:PowerBI_Close_And_Apply.png|Close and apply. | File:PowerBI_Close_And_Apply.png|Close and apply. | ||
File:PowerBI_Bar_Chart.png| | 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> | </gallery> | ||
{{article end | {{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= | |seealso= | ||
* [[Power BI]] | * [[Power BI]] | ||
}} | }} | ||
[[Category:How-to's]] |
Latest revision as of 13:10, 30 January 2024
Data from projects can be accessed by Power BI Desktop 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:
- 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 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.
Notes
- Use the search bar in Power BI to filter data fields.
How-to's
- How to show Indicator results in Power BI
- How to show Overlays in Power BI
- How to show polygon data in Power BI