# 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](https://docs.enlyze.com/en/integrations/power-bi/tutorials/querying-machine-productivity-metrics "mention").
* **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](https://docs.enlyze.com/en/integrations/power-bi/tutorials/querying-time-series-data-from-machine-variables "mention").