How to get data in Power BI Desktop using Envizi API
Open Power BI Desktop and from Home tab → Get Data, choose Web from the list.
Enter the API URL in the pop up form and click Ok (for details on how to construct the API URL, check out the API Technical Documentation)
If it is the first time you are setting this up, Power BI would prompt to ask you to input your connection credentials. Click Basic from the left hand side panel, and then input your Envizi user name and password. Leave the last field default and click Connect.
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.
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.
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:
Change the data type of all date related columns to be Date, and
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.
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.
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.