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 firstname.lastname@example.org
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
- Click on the clipboard icon to save the script. If you now want to import the data in Power BI, follow this article.
|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:
|LT - LogAlto Project|| Canada; Senegal; India
With the option checked, the locations will be split to 3 rows.
|LT - LogAlto Project||Canada|
|LT - LogAlto Project||Senegal|
|LT - LogAlto Project||India|
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.
Note: Any modification that is being done in the builder window will change the script in Real Time