Generate PowerBi export/import script

Generate a script to import a dataset in Power BI

This feature 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

LogAlto can give you access URL addresses of your datasets in the JSON format, which can for example be used to import data to Power BI

This feature allows you to customize a script that allows so you can edit some of the content at the source, which can be helpful if you are working with a large dataset (50,000 + records).

For smaller datasets, you can generate a url


Generate a script

1
Go to Analytics and Choose "Datasets" in the top right corner
2

Right click on the pre-generated URL if you do not want to edit it. To open the script edit box, click on the "Script" icon. 

3
Choose among the following options
Options Description
Start (optional) Determines at which row of of the dataset to start fetching the data. By default position is at 0.
You may want to start at a position different than 0 if you are importing your data in batches. This is a workaround when you have a lot of data and performance is impacted.
Maximum number of rows to fetch (optional) Determines how many rows of the dataset to fetch. If not specified, the dataset will return up to 5,000,000 rows.
User-friendly column names If checked, the columns will have a descriptive name instead of their codified name (e.g.: Column "Indicator title" would be returned instead of column "1822")
Split multiple values over multiple rows* If checked, columns with multiple values will be split over multiple rows, repeating all the other columns. Only available if there is a column with multiple values in the dataset. This setting will impact how you can create reports on the data. (See details below) 
Fetch empty columns If checked, each rows will include all the columns, even those without data. Otherwise, only columns with data will be included.
Default columns** If checked, the default columns of the dataset will be returned. If not, please select the columns to return.(See details below) 

*Split multiple values over multiple rows

This option splits rows containing cells with multiple values over multiple rows. For example see the following row without the option checked:

Project  Location
LT - LogAlto Project Canada; Senegal; India

With the option checked, the locations will be split to 3 rows.

Projet Location
LT - LogAlto Project Canada
LT - LogAlto Project Senegal
LT - LogAlto Project India

**Default columns

By default LogAlto chooses what it believes to be the most pertinent columns for the dataset. However, you can overwrite this setting and select the columns that are relevant to you. If unchecked you will be able to check each column you want returned in your dataset. Those left unchecked will be left out.

3
Click on the clipboard icon to save the script. If you now want to import the data in Power BI, follow this article.
4
Use the script in Power bi.
Note: Any modification that is being done in the builder window will change the script in Real Time