Integrate LogAlto with Power Bi

Power BI integration

The Power BI integration allows to use data in LogAlto (such as the project information, activities or indicator tracking, etc.) to create visualizations in Power BI. 

The Power BI integration is a premium feature: it is reserved for the LogAlto Configured and LogAlto+ plans.

If you are currently using the Free trial or LogAlto complete plan and wish to get access to Premium features, please contact us at info@logalto.com

Requirement: Install Power BI Desktop first

  1. Get the dataset's URL from LogAlto
  2. Import the dataset in Power BI
  3. Edit the dataset format in Power BI
  4. Import with generated script

Get the dataset's URL from LogAlto

  • Click Analytics in the main (left) menu
  • Click the "Datasets" tab (top right)
    • If you do not see the "Dataset" tab, it may be because this feature is not available on your platform. Contact your administrator to get that information. If you have a configured or LogAlto+ plan and do not yet have this integration, your administrator can contact us at support@logalto.com to get more information about that feature.
  • The list of datasets will be displayed
  • Copy the URL of the dataset you want to export to Power BI :
    • Either right-click on the URL (3rd column) and then select "Copy link address"
    • Or click on the link (3rd column) and then copy the URL of the new page
Refer to this article for more details regarding the specification of each dataset.

Import the dataset in Power BI

The Power Bi desktop app must be installed on your computer. 

Once you open Power BI;

  • Click Get Data in the top menu
  • Click "Web"     

A Power-Bi pop-up will appear.

  • Enter the URL that you copied in the previous step (dataset's URL)     
  • Enter your LogAlto username and password

A 

Edit the dataset format in Power BI

Once you've succesffully imported the dataset, Power BI will have guessed a few query operations for you : 

As you can see in the Applied Steps, Power BI converted the dataset, expanded the columns of data and meta data and changed data type according to content.

You can edit the steps by clicking on the wheel gear next to each one. For example if you want to hide some columns you can click on the Expanded data1 gear wheel.

From there you will have a window prompt to perform the desired edits. 

Once you're satisfied with the dataset, click " Close & Apply" in order to start creating the visualization

From here onwards, data can be manipulated directly in Power BI. 

An URL can be created through Power Bi to integrate the visualization to the dashboard in LogAlto through the embed a page feature. 

Import with generated script

In the case of large datasets, you might opt to import data via a script generated by LogAlto. Follow the steps in the appropriate article to generate the script, then follow these steps.

  • In Power BI desktop, click for a New source and choose Blank query

This will bring you to the query editor window.

  • In the menu, click on Advanced editor.

A blank (or near blank) text editor will pop up.

  • Erase the lines already existing in the editor and Copy/Paste the script you previously genered. 

  • Click on Done.

See the section on editing the query.

For more tips and ressources on using Power BI, consult their own guides and tutorials.