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
Go to Analytics and Choose "Datasets" in the top right corner
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.
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* | This option splits rows containing cells with multiple values over multiple rows |
| 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 is being removed. You can split columns and rows in Power BI by following the directions here: https://learn.microsoft.com/en-us/power-query/split-columns-delimiter#split-columns-by-delimiter-into-rows
**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
Note: Any modification that is being done in the builder window will change the script in Real Time