> For the complete documentation index, see [llms.txt](https://docs.enlyze.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.enlyze.com/en/integrations/power-bi/structure-of-the-enlyze-power-bi-connector.md).

# Structure of the ENLYZE Power BI Connector

The ENLYZE Power BI Connector establishes a connection between the ENLYZE API and Power BI. With it, data from the ENLYZE Data Platform can be easily queried and included in your Power BI reports.

## Data Tables

The ENLYZE Power BI Connector offers direct access to a set of tables. For a more detailed description of the specific data provided by every table, follow the provided links to our API.

* [**Sites**](https://app.enlyze.com/api/v2/redoc#operation/get_sites_v2_sites_get): All sites present in the ENLYZE Data platform.
* [**Machines**](https://app.enlyze.com/api/v2/redoc#operation/get_machines_v2_machines_get): All machines for all sites.
* [**Products**](https://app.enlyze.com/api/v2/redoc#operation/get_products_v2_products_get): All products that have been so far registered on the platform.
* [**Variables**](https://app.enlyze.com/api/v2/redoc#operation/get_variables_v2_variables_get): All active variables from all machines.
* [**Production Runs**](https://app.enlyze.com/api/v2/redoc#operation/get_production_runs_v2_production_runs_get): All orders registered on the platform from all machines.
* [**Downtimes**](https://app.enlyze.com/api/v2/redoc#operation/get_downtimes_v2_downtimes_get): All downtimes registered on the platform from all machines.

## Functions

The ENLYZE Power BI Connector offers two dedicated functions that enable to query additional data:

* **Machine Productivity Metrics**: offers the possibility to query time-based aggregated machine productivity KPIs. For more information about how to use this function, you can follow the tutorial [Querying Machine Productivity Metrics](/en/integrations/power-bi/tutorials/querying-machine-productivity-metrics.md).
* **Timeseries**: offers the possibility to query time series data from specific machine variables. For more information about how to use this function, you can follow the tutorial[Querying Time Series Data from Machine Variables](/en/integrations/power-bi/tutorials/querying-time-series-data-from-machine-variables.md).