How to access your project data in Power BI: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
| Line 12: | Line 12: | ||
| Under add '''Get Data''', select '''Web''' | | Under add '''Get Data''', select '''Web''' | ||
| Paste the link in the url field and select ok. | | Paste the link in the url field and select ok. | ||
| | | 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 visuals list, select the second (vertical) bar chart. | ||
| A preview should be added to your page section, indicating you need to drag or select a field. | |||
| In the detail panel, identify the x data values field. | | In the detail panel, identify the x data values field. | ||
| In the data panel, unfold the connection item and drag the name field from the list of properties to the x data value field. | | In the data panel, unfold the connection item and drag the name field from the list of properties to the x data value field. | ||
| | | Next, select a value property of the web connection, such as "AANTAL_INWONERS" and drag this property to the y data value field. | ||
| The bar chart should now be created. | | The bar chart should now be created. | ||
}} | }} | ||
| Line 24: | Line 25: | ||
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:PowerBI_Web_connection.png| | File:PowerBI_Web_connection.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_Empty_Bar_Chart.png|Vertical bar chart selected from the Visuals. | |||
File:PowerBI_Bar_Chart.png|Configured bar chart with neighborhood name and number of inhabitants. | File:PowerBI_Bar_Chart.png|Configured bar chart with neighborhood name and number of inhabitants. | ||
</gallery> | </gallery> | ||
Revision as of 14:24, 15 November 2023
Data from projects can be accessed by Power BI using a web connection for the GeoJSON endpoint.
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.
- A new panel opens, and by default, a table is created of all the properties.
- Click on the Close and Apply button.
- In the visuals list, select the second (vertical) bar chart.
- A preview should be added to your page section, indicating you need to drag or select a field.
- In the detail panel, identify the x data values field.
- In the data panel, unfold the connection item and drag the name field from the list of properties to the x data value field.
- Next, select a value property of the web connection, such as "AANTAL_INWONERS" and drag this property to the y data value field.
- The bar chart should now be created.
Copy URL for "Neighborhoods as GeoJSON"-endpoint.
Paste the URL and create a web connection.
Choose anonymous connection.
Created table for the GeoJSON web connection.
Close and apply.
Vertical bar chart selected from the Visuals.
Configured bar chart with neighborhood name and number of inhabitants.
