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. 

• 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.

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)     
• Go to the "Basic" tab
• Enter your LogAlto username and password

Once you've successfully 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.

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. 

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.

• 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.