Integrate LogAlto with Power Bi (or Power Query)

Power BI integration

The Power BI (or Power Query) integration enables the use of data from LogAlto—such as project information, activities, and indicator values—to create visualizations in Power BI or load live data into Excel.

• Click Analytics in the main (left) menu

• Click the "Datasets" tab (top right)

  

  IIf you don't see the "Dataset" tab, this feature may not be available on your platform. Please contact your administrator if this is the case. If you have a configured or LogAlto+ plan and lack this integration, your administrator can reach out to us at support@logalto.com for more information.

• 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

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 metadata and changed the 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" 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 generated. 

• Click on Done .

See the section on editing the query.