How to import data to PowerBI with the help of Rest API?

Below is an example of how to set up data import using an empty report:

1. Create a new report
2. On the Home tab, click Get Data
   
   
3. In the window that appears, select Other, then select Web from the list on the right. This can also be done by typing in Web in the search bar. After that, click Connect
   
   
4. On the From Web window that shows up, select Advanced from the radio button. Under URL parts specify the full address to the required Rest API method, in the example, the method for obtaining activities will be - https://backend.controlio.net/api/v1/activities
   
5. Under HTTP request header parameters (optional) in the first column select authorization, and in the second column specify Bearer value XXX where XXX is the token received from the Dashboard. After that, click OK
   
   
6. On the window that shows up, make sure that you're on the Anonymous tab,  then select the last item in the dropdown list and click Connect
   
   
7. If everything was specified correctly, PowerBI will make a request to RestAPI and open a window. At this stage, you can check the obtained data and add additional columns with derived functions
   
8. Once you are done with the previous step, click Close & Apply, after which the obtained data will become available for building reports in the 'Data' window