How to access your project data in Power BI: Difference between revisions

From Tygron Support wiki
Jump to navigation Jump to search
(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...")
 
No edit summary
 
(25 intermediate revisions by 3 users not shown)
Line 1: Line 1:
Data from projects can be accessed by [[Project 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|geo plugins}}
<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 new 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''.
| By default, create a table of all the properties.
| 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.
| Add a chart type, such as the bar chart.
| In the ''Visualization'' panel, select the second option named ''Stacked column chart''.
| In the detail panel, identify the x data values field.
| A preview should be added to your page section, indicating you need to drag or select a 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 ''Visualization'' panel, identify the '''X-Axis''' data field.
| 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.
| 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.
}}
}}
<gallery>
<gallery>
File:Geoplugin_inspect_dxf_file.png|Wizard to inspect features from a DXF file.
File:PowerBI_Export_GeoJSON.png|Copy URL for "Neighborhoods as GeoJSON"-endpoint.
File:Geoplugin_inspectable_geometries.png|Geo Plugin detail panel indicating the amount of features that can be used for configuration.
File:PowerBI_Web_connection.png|Paste the URL and create a web connection.
File:Geolink_matching.png|The matching tab of the geolink detail panel with the ''Select'' buttons.
File:PowerBI_Anonymous_connection.png|Choose anonymous connection.
File:Geolink_select_attribute.png|Select the attribute LAYER from the attribute set of the DXF features.
File:PowerBI_web_connection_table.png|Created table for the GeoJSON web connection.
File:Geolink_select_values.png|Select a value for the attribute LAYER.
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>
</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]]

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:
  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 Get Data, select Web.
  9. Paste the link in the url field and select Ok.
  10. In the Access Web content step, choose the default option and select Connect.
  11. A new panel opens, and by default, a table is created of all the properties.
  12. Click on the Close and Apply button.
  13. In the Visualization panel, select the second option named Stacked column chart.
  14. A preview should be added to your page section, indicating you need to drag or select a field.
  15. In the Visualization panel, identify the X-Axis data field.
  16. In the Data panel, unfold the connection and drag the name field from the list of properties to the X-Axis data field.
  17. Next, select a value property, such as AANTAL_INWONERS and drag this property to the Y-Axis data field.
  18. 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.

  • Stacked column chart with neighborhood name and number of inhabitants.

Notes

  • Use the search bar in Power BI to filter data fields.

How-to's

See also

Retrieved from "https://support.tygron.com/w/index.php?title=How_to_access_your_project_data_in_Power_BI&oldid=58115"