5. Example of a Use Case: Importing Ekran System Data into Power BI Report Templates


This use case is for Power BI reports. The instructions below describe how to use Ekran System Data Connector to import data from Ekran System into report templates created in Power BI.


To import data from Ekran System into a Power BI report template by using Ekran System Data Connector, do the following:

1. Install and configure the Ekran System Data Connector (as described in this Ekran System Data Connector Guide).

2. Open the required report template in Power BI Desktop.

3. Open the Ekran System Management Tool application, and click on the button where the username is displayed.

   

4. On the Manage account page that opens, click the Copy link to copy the Active API key.

   

5. In the Power BI report template that was opened, click Transform data > Edit parameters to open the Edit Parameters page.

   

6. Replace the value in the ApiKey field with that copied from the Management Tool.

7. Replace the value in the ApiUrl field with the URL of Ekran System Data Connector.

NOTE: You need to define the hostname of the machine where you installed the Ekran System Data Connector. e.g. https://<hostname>/ekranapi

8. If required, change the values in the From and To fields (they are only used for the User Productivity dataset).

   

9. Click OK, and then click Apply changes.

   

10. Wait until all the data is imported into the report template, and the data will then be displayed in the reports.


Examples showing Power BI reports that use data imported from Ekran System:

Idle Time and Work Time report.

   

Interactive Monitoring report.

   

User Productivity report.