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.