Power BI Configuration

1. Run Power BI.
   
2. You can close the introduction page as we are going to explain the steps on the main page of the Power BI Desktop.
   
3. On the Power BI Desktop, under the Home ribbon click on Get Data and select Web as follows:
   
1. 
   
4. On the From Web page click on Advanced:
   
1. 
   
5. Click on the first line of URL parts and enter the main Atria API address: 
   
1. http://apibuild.a101labs.com/
   
2. 
   
6. At this stage, you must have your Token received from “Generate API Access Token” in the Atria platform. The token should be entered as an Authorization header. Click on the HTTP request header parameters and enter Authorization in the header field:
   
1. 
   
7. Click on the value field and enter the Bearer {token} as follows:
   
1. 
   
8. From Web page should look like this to be able to retrieve data:
   
1. 
   
2. Click on OK
   
9. Once you click on OK, Power BI Desktop starts to connect to Atria External API. It is important to note that the data you receive via Atria API is in JSON format and in order to view JSON data in a table structure please follow the below steps:
   
10. On the Power Query Editor page which will be opened automatically once you retrieve data from Atria API, under Convert Menu click on parameters Query on the left side of the page and then select RECORD next to the data field
    
1. 
   
11. On the next page, you will see endDates and customers Lists. Click on the List next to endDates.
    
12. Here we will have data shown in JSON format and to extract data and show it in a table structure, under Transform Menu click on Into Table icon on the top left side of the page:
    
1. 
   
13. To Table page will be opened to define the way you want to create your table:
    
1. 
   
2. Click on OK
   
14. We need to extract columns from the list shown in Column 1, to extract columns click on  icon next to Column1 header:
1. 
   
2. The column select page will be shown.
   
15. On the Column Select page, select the columns you want to be shown. In this example, we just need to click on OK
    
1. 
   
16. Once you click on OK, the parameters table will be shown and we can use it as a parameter to retrieve our required information.
    
1. 
   
17. Now that we have the endDates specified, we can use it as a parameter to send to our External API and retrieve information for all periods of time. In order to create a parameter please follow the below steps.
    
18. Under Home ribbon, click on Manage Parameters and select New Parameter:
    
1. 
   
19. In Manage Parameters page, enter a Name for the parameter, select Text for Type and enter a Current Value as below:
    
1. 
   
2. Click on OK
20. Click on the New Source and select Web
    
21. on the From Web page, click on Advanced and on the first line of the URL parts enter the following link:
    
1. http://apibuild.a101labs.com/api/billing/
   
22. On the second line of the URL parts click on the  icon and from the list shown click on the parameter. endDate parameter that you created previously will be selected automatically.
    
23. Enter the Authorization and Bearer token as a header parameter and click on OK:
    
1. 
   
2. Here we have the data for one period and we are going to create a function that iterates through parameters table and invokes data from External API
   
24. To create the function, select endDate (2) table, then right-click and select Create Function, enter a name for Function Name
    
1. 
   
2. Click on OK
   
25. Click on parameters table on the left-side and then under Add Column ribbon click on Invoke Custom Function
    
1. 
   
26. Invoke Custom Function page will be shown. Enter a new column name and select your function (in this example GetSummary) from the drop-down box:
    
1. 
   
2. endDate parameter will be shown to send it as a parameter to our function:
   
3. 
   
4. Click OK to close the window.
   
27. A warning message will be shown regarding data privacy. Click on Continue:
    
1. 
   
28. in the Privacy Levels page, click on the "ignore privacy levels check for this file" and click on Save:
    
1. 
   
29. Right now, our function uses the endDate table as a parameter and iterates through the values of the table and sends each value as a parameter to our External API. This may take a bit to send requests and receive the responses. You may just need to extract the columns and rows via the same process on steps 12 to 16.
    
30. Once you finish the above steps, you will have all the information and you can start preparing data or creating visualizations or reports in your application.