Change Properties in a Data Source View (Analysis Services)

Applies to: SQL Server Analysis Services Azure Analysis Services Fabric/Power BI Premium

After defining a data source view using the Data Source View Wizard and adding tables, views, named calculations, and named queries to the data source view, you may want to change properties related to:

  • Data source view matching criteria

  • Advanced data source view options

  • Object names

  • Object metadata

You can also view object metadata retrieved from the data source that you cannot modify.

Viewing or Changing Data Source View Properties

Data source view properties, other than a description of the data source view, are set by the Data Source View Wizard when you initially define the data source view. The following table lists and describes the properties of a data source view.

Note

The Properties pane shows properties for the .dsv file as well as the DSV object. To view the properties of the object, double-click it in Solution Explorer. The Properties will update to reflect the properties you see in the following table.

Property Description
Data Source Specifies the data source within the data source view whose properties you are viewing
Description Specifies a description of the data source view
Name Specifies the name of the data source view that appears in Solution Explorer or the Analysis Services database. You can change the data source view name here or in Solution Explorer.
NameMatchingCriteria The name matching criteria for the data source. The default is (none) if primary key - foreign key relationships were detected by the Data Source View Wizard. Regardless of whether this property was set by the Data Source View Wizard, you can specify a value here. If database relationships exist and you specify name matching criteria, both will be used to infer relationships between existing tables and newly added tables.
RetrieveRelationships Specifies whether relationships are retrieved from the database. Default is True.
SchemaRestriction Specifies the restrictions, if any, on the schemas retrieved from a data source. By default, no schema restrictions exist.

Viewing or Changing DataTable Properties

DataTable properties are the properties of tables, views, and named queries in a data source view. These properties are set when any of these objects is added to the data source view. The following table lists and describes the properties of DataTable objects in a data source view.

Property Description
AllowChangesDuringGeneration Specifies whether the Schema Generation Wizard has permission to overwrite a data source view table during regeneration. This property will only exist on tables initially generated by the Schema Generation Wizard. For more information, see Understanding Incremental Generation.
DataSource Specifies the data source for the object. You cannot edit this property.
Description Specifies the description for the table, view or named query. If the underlying database table or view had a description stored as an extended property, this value appears. You can edit this property.
FriendlyName Specifies a name for the table or view that is easier for users to understand or more relevant to the subject area. By default, the FriendlyName property of a table or view is the same as the Name property of the table or view. The FriendlyName property is used by OLAP and data mining objects when defining object names based on tables or views. You can edit this property.
Name Specifies the name of the underlying table or view, or the name of the named query. The Name property is used by OLAP and data mining objects when defining object names based on named queries. This property is only editable for named queries.
QueryDefinition Specifies the named query definition. This property is only applicable to named queries and is not directly editable. To edit this property, you edit the named query itself.
Schema Specify the database schema applicable to the table, view or named query. This property is not editable.
TableType Specifies the type of table for the table, view or named query. This property is not editable.

Viewing or Changing DataColumn Properties

DataColumn properties are the properties of columns in tables, views, and named queries in a data source view. These properties are set when any of these objects is added to the data source view, either from the underlying table or view, from a named query, or as defined by a named calculation. The following table lists and describes the properties of DataColumn objects in a data source view.

Property Description
AllowNull Specifies the nullability property of the column based on the column in the underlying table, value or named query. This property is not editable.
DataType Specifies the data type of the column based on the column in the underlying table, value or named query. This property is not directly editable. However, if you need to change the data type of a column from a table or view, replace the table with a named query that converts the column to the desired data type.
DateTimeMode Specifies the date serialization format for DateTime columns. The default value is UnspecifiedLocal. This property is editable.
Description Specifies the description for the column. If the underlying database column had a description stored as an extended property, this value appears. You can edit this property.
FriendlyName Specifies the name for a column from a table or view that is easier for users to understand or more relevant to the subject area. By default, the FriendlyName property of a column from a table or view is the same as the Name property of the column. The FriendlyName property is used by OLAP and data mining objects when defining attributes based on columns from tables or views. You can edit this property.
Length Specifies the maximum length of the column, based on the data in the column in the underlying table or view.
Name Specifies the name of the underlying column, or the name of the named calculation. The Name property is used by OLAP and data mining objects when defining attributes based on named calculations. This property is only editable for named calculations.

See Also

Data Source Views in Multidimensional Models
Work with Diagrams in Data Source View Designer (Analysis Services)