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
- Get the dataset's URL from LogAlto
- Import the dataset in Power BI
- Edit the dataset format in Power BI
- Import with generated script
Get the dataset's URL from LogAlto
- Click Analytics in the main (left) menu
- Click the "Datasets" tab (top right)
- 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
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.