Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Applies to: 
SQL Server Analysis Services 
Azure Analysis Services
Fabric/Power BI Premium
After defining a data source view by using the Data Source View Wizard and adding tables, views, named calculations, and named queries to the data source view, you might 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 can't modify.
View or change data source view properties
The Data Source View Wizard sets data source view properties, other than a description of the data source view, 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 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're 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 are detected by the Data Source View Wizard. Regardless of whether this property is set by the Data Source View Wizard, you can specify a value here. If database relationships exist and you specify name matching criteria, both are used to infer relationships between existing tables and newly added tables. |
| RetrieveRelationships | Specifies whether to retrieve relationships 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. |
View or change DataTable properties
DataTable properties represent the properties of tables, views, and named queries in a data source view. Set these properties when you add any of these objects 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 can overwrite a data source view table during regeneration. This property exists only 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 can't edit this property. |
| Description | Specifies the description for the table, view, or named query. If the underlying database table or view has 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. OLAP and data mining objects use the FriendlyName property 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. OLAP and data mining objects use the Name property when defining object names based on named queries. You can edit this property only for named queries. |
| QueryDefinition | Specifies the named query definition. This property is only applicable to named queries and isn't directly editable. To edit this property, edit the named query itself. |
| Schema | Specifies the database schema applicable to the table, view, or named query. This property isn't editable. |
| TableType | Specifies the type of table for the table, view, or named query. This property isn't editable. |
View or change DataColumn properties
DataColumn properties represent the properties of columns in tables, views, and named queries in a data source view. Set these properties when you add any of these objects 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 isn't editable. |
| DataType | Specifies the data type of the column based on the column in the underlying table, value, or named query. This property isn't 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 has 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. OLAP and data mining objects use the FriendlyName property 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. OLAP and data mining objects use the Name property when defining attributes based on named calculations. You can edit this property only for named calculations. |
See also
Data Source Views in Multidimensional Models
Work with Diagrams in Data Source View Designer (Analysis Services)