How to configure the Power BI Dashboard

Prerequisites

To configure the Power BI file to receive your data, you will need an API key (AESA access credentials). If you don't have an API key, or if you'd like to create new credentials specific to the Power BI report, this wiki article explains the steps to follow.

Warning

When you first open the file, it is completely normal to see the following errors. These will disappear once the data has been refreshed (i.e., after completing step 3 of the procedure below).

Procedure

1. In the main Power BI menu, Home section, click Transform data to access the Power Query Editor page.

   

2. On the left you will find the list of queries. You will need to save the following information:

   1. ENVIRONMENT_URL with your environment's URL in the format: https://<<your_domain>>.aidi.io/. It is important to keep the / at the end of the URL to ensure the requests work properly.
   2. API_ID with your AESA key's identifier
   3. API_SECRET with your AESA key's password (Secret)

   

   

   

3. After modifying this data, save the file (Ctrl+S) and click Apply. This will start the data update. It is possible that some of the following windows appears :

   1. Access Web content : Click on Connect.
   2. Privacy levels : Click on Ignore Privacy Levels, then Save.

4. For subsequent data updates, go to the main menu, Home section, and click Refresh to start the data update.