How to get data in Power BI Desktop using Envizi API

1. Open Power BI Desktop and from Home tab → Get Data, choose Web from the list.
   
   

   

   
   
   

2. Choose ‘Advanced’
   
   

   

   
   
   

   
   

3. Enter API Access Token details

• Enter the URL path of the report (for details on how to construct an API URL, check out the API Technical Documentation)

• Enter the word Authorization on HTTP request parameters field, then on the next field enter the word Bearer followed by the access token

• Select OK button to continue

4. Choose Anonymous from the left option and select Connect button to continue

   

5. Depending on the amount of data being retrieved, it may take some time to load data preview in the Power Query Editor, which shall open in a new window. Click To Table under the Transform tab and then click Ok in the pop up form.
   
   

   

   
   
   

6. By now all data should be organized into a single column. Click the two-way expansion arrow beside the column header, in the pop up form un-select the last option 'Use original column name as prefix', and then click Ok.
   
   

   

   
   

7. The data should now be presented as a table format in Power Query Editor. You may now continue with normal Power Query transform operations such as rename columns, re-arrange column orders, changing column data types etc. Since all data returned from the API is in string format by default, so for a minimum it is recommended to:

   1. Change the data type of all date related columns to be Date, and

   2. Change the data type of all numeric columns to be numeric data type (Decimal Number, Whole Number etc.)
      
      This will facility the analysis and reporting in the data model.
      
      

      

      
      
      

8. Click Close & Apply to save the query and populate all data into Power BI data model. Depending on the amount of data to be retrieved, this may take some time as Power BI needs to download all requested data from Envizi.
   
   

   

   
   
   

9. You can now start to make Power BI reports and visuals by utilizing the loaded data model. Multiple Envizi API reports can be loaded into Power BI to form the base data set for your Power BI reporting.
   
   

   

Issues with Time Out

Power BI Time Out

Power BI employs a default time out setting for Web Service API calls. If your API query turns out to be very large and requires longer than usual time to download all the data, you can extend the time out setting by specifying it in the 'Advanced' form.