How to receive data in Power BI from Yaware?

Power BI is an analytics platform from Microsoft. It offers a set of services that connect data from different sources and present it in the form of interactive analytical dashboards.
It means you can connect data from Yaware to Power BI and display it in the way you need it. And also, combine statistics from different sources, carry out calculations inside Power BI, build such reports and charts as you wish.
Benefits of connecting data from Yaware to Power BI:
  • custom dashboards according to their needs;
  • combined use of data from different sources;
  • calculations inside Power BI;
  • general and personal access to dashboards.

To connect to Power BI follow these steps:

  1. Register and log in to https://rapidapi.com/  portal.
  2. Follow the link https://rapidapi.com/api4yaware/api/yaware-timetracker
  3. Select the required method at the bottom left of the screen.
  4. Get your API key in your Yaware.TimeTracker account – in the “Personal Information” section.
    2021-10-18_16-22-24
  5. Paste it into the “access_key” field in the “Required Parameters”. Some methods have additional required or optional parameters. If necessary, adjust the default values or enter the parameters you need.
  6. From the drop-down list at the bottom left of the page, select the HTTP => HTTP / 1.1 option.
  7. Open Power BI and select the function “Get Data” -> “Other” -> “Web”.
  8. In the window that opened, select “Advanced”.
  9. In the first field “URL parts” paste https://data1.yaware.com/export.
  10. In the second field “URL parts”, between “POST” and in “HTTP / 1.1”, paste a piece of code obtained from the RapidAPI portal.
  11. Click OK to get Yaware data in Power BI.

Was this article helpful?

Related Articles