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
Setup Instructions
Download Microsoft Power BI Desktop from Power BI Desktop
Download Frontu Power BI Connector
Open Connector file with Power BI Desktop application
Enter your Frontu account details:
Domain
Your Frontu account name. e.g. DEMO.frontu.com
Access Token
You can find your API Access Token in the Frontu settings
RangeStart
Date from which data will be synchronised. If you're using Frontu for a long time, we recommend to skip old data and use recent year or two.
RangeEnd
Date to which data will be synchronised.
FirstSync
Leave it TRUE if you're using Desktop version only or you're preparing data to be published to the Cloud.
5. Click "Load" and wait while all your account information will be downloaded. Synchronisation speed depends on the amount of data you have collected using Frontu and your computer performance.
6. You will see all possible entities and fields in the “Data” tab, also one predefined dashboard.
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
To use Power BI Cloud, you need to have at least Power BI PRO license. See more: https://www.microsoft.com/en-us/power-platform/products/power-bi/pricing
Power BI Cloud allows you to update data in your reports automatically, get notifications and join data with other sources.
Setup Instructions
Setup Instructions
Follow all Power BI Desktop setup instructions mentions below
Wait while all data will be synchronised and click Publish button in the toolbar
Choose a workspace you want to publish report to
Wait while data report will be published and open report in the Power BI Cloud
In the report, click "..." and choose "View Semantic model"
Click File -> Settings
Click on "Parameters" and change "FirstSync" to value "FALSE"
Configure Refresh frequency according your business needs
