Skip to main content

Power BI and ABRA Flexi

How to Connect ABRA Flexi to Power BI via REST API and Analyze Data

Written by Petr Pech

Data from ABRA Flexi can be analyzed in Power BI. You can retrieve it via the REST API in .csv format, which Flexi offers as one of its export formats.

ℹ️ You need the desktop version of Power BI. The web version cannot load data from a web address.

Step 1: Install Power BI Desktop

Download and install Power BI Desktop from the Microsoft website and launch the application.

Step 2: Choose a data source

On the Home ribbon, expand the arrow next to Get data, select Other, and then choose Web.

Step 3: Enter the data address

Enter the address of the data you want to analyze from the REST API. As an example, we'll use account transactions from the demo application: https://demo.flexibee.eu:5434/c/demo/pohyb-na-uctech.csv?limit=0

Step 4: Sign in and load

Choose Basic authorization and enter the username and password you use to sign in to ABRA Flexi. The Navigator dialog will open with a preview of the data — you can transform it before loading. Confirm by clicking Load, and the data will be ready for processing.

How to get the address of other data

If you want to analyze a different record type than account transactions, simply change the address you enter. The easiest way is to copy it from the browser's address bar in the web interface and replace /flexi/ with /c/:

We'll modify the address as follows — add the .csv format and the pagination parameter (the default is limit=20, while limit=0 means all data):

You can further narrow down the data using filtering and detail levels. You can find the complete list of records in the web interface.

Setup as a service

We can also handle the connection and data visualization for you — we work with both standard outputs and custom user queries. The price corresponds to the hourly rate for service work according to our price list. Write to us at podporaflexi@abra.eu.

Related articles

Did this answer your question?