Reporting through PowerBI

If you want to analyze the data with visuals and graphic charts, we suggest using specialized tools, such as Power BI analytics.

Updated over a week ago

Microsoft Power BI Desktop

To create your own reports you can use Microsoft Power BI Desktop application and Frontu API connector which will download all needed information from Frontu account.

Setup Instructions

  1. Download Microsoft Power BI Desktop from Power BI Desktop

  2. Open Connector file with Power BI Desktop application

  3. Enter your Frontu account details:

a. Domain & API Access Token

b. You can find your API Access Token in the Frontu settings under Settings > API section

5. Click "Load" and wait while all your account information will be downloaded.

6. You will see all possible entities and fields in the “Fields” tab.

7. Create your own reports using tools provided by Microsoft Power BI Desktop software.

Please note below listed points if your reports are time/date specific or you would like to include custom fields to your reporting.

  • All dates are displayed in UTC (+0) time zone, if your reports are time/date specific, you need to create separate columns for needed fields with “Local time” option.

If you’re using custom fields - you have to expand “customValues” column on each table. Expanded columns will have GUID identifiers. To identify custom field, you can find custom field guid in it’s preview on Frontu administration panel.

Microsoft Power BI Cloud

You can use Frontu Tools Analytics by ELVA that will help you to get an information about work orders management in your company. Using this add-on you will have ready to use reports with possibility to add more.

For more information, please check the guidelines or watch our webinar video.

Did this answer your question?