Data from ABRA Flexi for analysis in Power BI can be retrieved using the REST API. To process the data in Power BI, we will use the .csv format, which ABRA Flexi offers as an export format.
Steps for analyzing selected data
1. Download the desktop version of Power BI (the web version of Power BI does not support loading data from a web address). Power BI Desktop is available for download on the Microsoft website.
2. Launch the Power BI Desktop application
3. In Power BI Desktop, on the Home ribbon, click the arrow next to Get Data, then select Other from the list and choose Web
4. In the next step, enter the address of the data you want to analyze, which you can obtain from the ABRA Flexi REST API. As an example, we will enter the account movements from the demo application: https://demo.flexibee.eu:5434/c/demo/pohyb-na-uctech.csv?limit=0
Data can be filtered and narrowed down using detail levels.
If you want to analyze data other than account movements, you can change the URL entered. You can find the correct address for your data in the web interface from the browser's address bar — you just need to replace /flexi/ with /c/ as shown in the screenshot. Append the format .csv and a limit parameter to the address (the default is limit=20; limit=0 returns all data):
Modify the address as follows:
Alternatively, you can find the complete list of records in the web interface.
5. In the next step, you will be prompted to authorize. Select Basic and enter the username and password you use to log in to ABRA Flexi.
6. After confirming your credentials, the Navigator dialog box will appear. It displays the data from ABRA Flexi in a table, as recorded in the CSV file. You can transform the data before loading it into the report.
7. After clicking Load, you can start working with the selected data in Power BI.
For more information about working in Power BI, refer to the Power BI documentation on the Microsoft website.
Need help?
If you have any questions about the application, please contact us at podporaflexi@abra.eu or via the chat window in the bottom right corner.