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 provide you with the URL addresses of your datasets in the JSON format. This makes it possible to import data to Power BI.
This feature allows you to customize the URL so that you can edit some of the content at the source, which can be useful if you'e 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") |
| 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) |
*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.