Custom Styles

Power BI Integration - Overview

Power BI Integration - Overview

Lanteria introduces the Power BI templates that can be used to improve the flexibility of the Lanteria HR dashboards. Templates are based on the Lanteria HR statistics and allow extending and customizing visualizations.

The templates are available for the following dashboard sections:

  • Core HR and Compensation
  • Absences
  • Performance
  • Learning

Note: For a full list of templates, click here.

Connecting Data Source to Power BI Templates

The Lanteria HR timer job exports data to the SQL database in the format that can be used for Power BI. This database can then be connected to the Power BI template as a data source.

Do this for each template you will be using by following these steps:


1. Open a Lanteria HR template (the *.pbix file).

Lanteria HR - Power BI Integration.

2. Next, click Edit Queries > Data source settings.

Lanteria HR - Power BI Integration.

3. In the Data source settings dialog, click Change Source.

Lanteria HR - Power BI Integration.

4. Specify the name of the SQL server and database that stores the Lanteria HR data for Power BI (it starts with ESDB_). Click OK.

Lanteria HR - Power BI Integration.

5. To finalize connecting the data source, click Apply Changes.

Adding New Data

Power BI templates allow modifying existing datasets and building flexible visualizations by adding the data from different data sources.

For example, to view the Company Absence Statistics chart data by country, the LanteriaHR_Countries table is to be added to the template. To add a new table from the ESDB_* database, follow these steps:


1. In Power BI Desktop, click Get Data > SQL Server.


Lanteria HR - Power BI Integration.

2. Specify the SQL Server and database, select the type Import and click OK.

3. Now the new data can be imported by selecting a table or view from the list and clicking Load. 

Lanteria HR - Power BI Integration.

4. After the table is loaded, use its data for building custom visualizations.

Lanteria HR - Power BI Integration.

Note: Please note that for using the Power BI templates, preliminary setup is required for both Lanteria HR and Power BI. Follow this link for details.


We are trusted
by our clients

We are trusted by our partners

Microsoft Gold PartnerProduct Hunt CapterraSoftware Adviceg2
Book a Demo
Get more HR trends, news, tips and guides to streamline your operations. We promise we don’t spam.
We care about the protection of your data. Read our Privacy policy.


Here’s what our customers say

Ekaterina Avatar
Ekaterina K.

"Top-notch HR solution with excellent support team"

I was able to tailor the system to fit the unique needs of my organization, from creating custom fields to setting up workflows and approvals. This level of flexibility made it so easy to integrate into our existing HR processes, and it's made a real difference in our daily operations.
Read more reviews
Aleksandra Avatar
Aleksandra K.
"Lanteria is a top SharePoint HR software with a great team behind it"
    Lanteria HR is a great product that has even better team behind it. And as for a SharePoint-based product the Lanteria HR system looks very modern and runs quickly.
Akshay Avatar
Akshay U.
"Lanteria is the most flexible and secure HRMS I had"
    Our team is on Office 365, and Lanteria solves a big problem for us because it works so well with Microsoft products.
Hanna Avatar
Hanna B.
"Al-star for employee performance management and reviews"
   The Performance module gives us a straightforward dashboard where we can see all the vital stats about our employees' work performance. And, it updates in a flash so we're always in the know.

Similar Posts