Integration with Power BI

With fairly simple means you can integrate Balthzar with Power BI from Microsoft. In this way you get a powerful analysis tool at a reasonable cost. Of course, you can integrate in the same way with other similar tools. Read below to find out a little more. Some videos may require a password. You who are a customer can contact our support to get a password.

Balthzar Power BI -Introduktion

Simple video that shows how to get started with Power BI together with Balthzar.


Balthzar Power BI -How to use a template

Simple video that shows how to link a template you have downloaded to your own balthzard database


Balthzar - Prerequisites for using Power BI -Balthzar

The following is currently required to use Power BI with Balthzar.
  • Local installation of Balthzar
  • Power BI Desktop and necessary licenses for this
  • Some knowledge

Training in Power BI

To get started quickly with Power BI, there are many courses online that do not cost so much. Feel free to try below.

Udemy, Microsoft Power BI - Up & Running With Power BI Desktop

Balthzar - Some useful SQL queries

Below are some examples of SQL queries that are useful when retrieving data for Power BI. XXXX must be replaced with your own company page, which you will find at the bottom right of the client (4 digits)
  • History Per day, stopping reasons, driving time, stopping time etc.
    select * from object_history_per_day2_view where company_id = 'xxxx'
  • History manufacturing order
    ​​​​​​​select * from object_card_history_view where company_id = 'xxxx'

Balthzar - Power BI - ready-made templates

Below we will shortly post ready-made templates that you can download and use. The templates are delivered "as is". It is then free to change in these templates for their own needs. All support regarding these templates and Power BI will be charged.

Good luck with Balthzar & Power BI

Per Lorentsson