Important: Please note that the Report Server on the server is not running under the account of a domain user, but under the user "IIS_USER". This means that for file-based data sources, e.g. located on the server of the Report Server, their access permissions must be set up for the same user "IIS_USER".
CSV connection settings
▪ Server or file path: File path or URL[:Port]
▪ Username and Password
▪ Table name
▪ Separator character: enter \t for the TAB separator
▪ Framing character
▪ Number of rows to skip
▪ The first row contains column names: first line is a header
▪ Allow breaks in field contents (if framing character is set)
▪ In-Memory mode: With this option all data will be loaded into memory at first. This leads to a longer loading phase of the data source, however results in faster queries afterwards. Using this option leads to an increased load on the server and can require adjusting report templates as the data type of columns with unusual data types might change.
JSON connection settings
▪ Server or file path: File path or URL[:Port]. Data source parameters can be inserted into the URL using the syntax {{ParameterName=StandardValue}}. For more information, see the Data source parameters section.
▪ Username and Password
▪ Name of the root table. If no value is defined, the default value of the data source is used.
▪ In-Memory mode: With this option all data will be loaded into memory at first. This leads to a longer loading phase of the data source, however results in faster queries afterwards. Using this option leads to an increased load on the server and can require adjusting report templates as the data type of columns with unusual data types might change.
Microsoft Excel connection settings
▪ Server or file path: File path or URL[:Port]
▪ Username and Password
▪ Sheet names: Several Excel worksheets, which must be setup as tables, can be specified using a comma-separated values format.
▪ The first row contains column names: first line is a header
▪ In-Memory mode: With this option all data will be loaded into memory at first. This leads to a longer loading phase of the data source, however results in faster queries afterwards. Using this option leads to an increased load on the server and can require adjusting report templates as the data type of columns with unusual data types might change.
RSS/XML connection settings
▪ Server or file path: File path or URL[:Port]
▪ Username and Password
▪ In-Memory mode (for XML data sources): With this option all data will be loaded into memory at first. This leads to a longer loading phase of the data source, however results in faster queries afterwards. Using this option leads to an increased load on the server and can require adjusting report templates as the data type of columns with unusual data types might change.
Tip: The Atom format is not supported for a RSS data source.