Generate export URL
Generate a link to export a dataset
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 the URL so you can edit some of the content at the source, which can be helpful if you are working with a large dataset. 
Generate a url
- 1
-
Right click on the pre-generated URL if you do not want to edit it. To open the URL edit box, click on the "link" icon.
- 2
- 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. |
| Number of rows to fetch (optional) | Determines how many rows of the dataset to fetch. If not specified, the dataset will return up to 1,000,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 URL. If you now want to import the data in Power BI, follow this article.