Enter the name of the data source
Select one of the following types:
Load data from a local Excel file
Specify URL to an Excel file. With or without credentials.
Allows connecting directly to OneDrive and retrieving data from an Excel sheet
Allows connecting directly to Google Docs and retrieving data from a sheet
Will be shown when relevant for Google Drive etc.
Enter the password that works with the email account above.
Enter the URL for the file
Will load the first sheet visible in the Excel file
Will show all sheets in the file and allow you to pick the sheet you want to import
Will automatically look for the first row where there are many columns filled out, thereby bypassing e.g. headers.
Skips the number of lines entered from the file and starts loading data from the line below
Assumes data is available in the first row
If this option is checked, the file including the first line will be loaded and instead of utilizing the first row as column headers all columns will be named like "Column1, Column2 etc." and at the same time load the first line of data as "data".
Use this setting to determine how often you would like to refresh your data from this data source.