Commit 4d228d6

title: "Connection String Properties (Analysis Services) | Microsoft Docs"

ms.custom:

- "SQL2016_New_Updated"

**Http(s) connections to [!INCLUDE[ssGemini](../../includes/ssgemini-md.md)] workbooks (.xlsx, .xlsb or .xlsm files)**

**Http(s) connections to BI Semantic Model Connection files**

**Embedded [!INCLUDE[ssGemini](../../includes/ssgemini-md.md)] connections**

title: "PowerShell scripting in Analysis Services | Microsoft Docs"

ms.custom:

- "SQL2016_New_Updated"

|Tabular instances and databases|Supported for local and remote administration, at all compatibility levels.<br /><br /> SQLAS cmdlets for Tabular models at the 1200 compatibility level using Tabular Model Scripting Language (TMSL) in JSON instead of XMLA.|

|[!INCLUDE[ssGemini](../../includes/ssgemini-md.md)] for SharePoint instances and databases|Limited support. You can use HTTP connections and the SQLAS provider to view instance and database information.<br /><br /> However, using the cmdlets is not supported. You can't use Analysis Services PowerShell to backup and restore an in-memory [!INCLUDE[ssGemini](../../includes/ssgemini-md.md)] database, nor should you add or remove roles, process data, or run arbitrary XMLA script.<br /><br /> For configuration purposes, [!INCLUDE[ssGemini](../../includes/ssgemini-md.md)] for SharePoint has built-in PowerShell support that is provided separately. For more information, see [PowerShell Reference for Power Pivot for SharePoint](../../analysis-services/powershell/powershell-reference-for-power-pivot-for-sharepoint.md).|

|Native connections to local cubes<br /><br /> “Data Source=c:\backup\test.cub”|Not supported.|

|Embedded connections to [!INCLUDE[ssGemini](../../includes/ssgemini-md.md)] databases<br /><br /> “Data Source=$Embedded$”|Not supported.|

|Local server context in Analysis Services stored procedures<br /><br /> “Data Source=*”|Not supported.|

The definition of an XML Schema definition language (XSD) schema for the [!INCLUDE[ssASnoversion](../../includes/ssasnoversion-md.md)] object definition language is based on the definition of the schema elements and hierarchy in this section.

You must have a library that supports the BI semantic model connection content type. For more information, see [Add a BI Semantic Model Connection Content Type to a Library &#40;Power Pivot for SharePoint&#41;](../../analysis-services/power-pivot-sharepoint/add-bi-semantic-model-connection-content-type-to-library.md).

All computers and users that participate in the connection sequence must be in the same domain or trusted domain (two-way trust).


Do not use the **Database** property; it is not used when specifying the location of a [!INCLUDE[ssGemini](../../includes/ssgemini-md.md)] workbook.

2. Click **From Analysis Services** and use the Data Connection Wizard to import the data.

4. On the next page, click **Next** again. Although you are prompted to select a database, you can only use the one database that is specified in the BI semantic model connection.

1. **Base URL** is optional. You should specify it if a data service document provides multiple feeds. Base URL should specify the portion of the URL that is common to all the feeds (for example, the server name and site). If you are creating a data service document to a Reporting Services report, the base URL would be the report server URL and report.

The Web service URL can include parameters that filter or select a subset of data. The application or service that provides the feed must support the parameters that you specify in the URL.

|--------------|---------------------|-----------------|

|Default Image|False|Specifies which column provides an image that represents the row data (for example, a photo ID in an employee record).|

|Default Label|False|Specifies which column provides a display name to represent row data (for example, employee name in an employee record).|

|Keep Unique Rows|False|Specifies which columns provide values that should be treated as unique even if they are duplicates (for example, employee first name and last name, for cases where two or more employees share the same name).|

|Row Identifier|False|Specifies a column that contains only unique values, allowing that column to be used as an internal grouping key.|

|Summarize By|Default|Specifies reporting client tools apply the aggregate function SUM for column calculations when this column is added to a Field list. To change the default calculation, select it from the dropdown list. This property applies only to columns of type that can be aggregated.|

Uses the SOAP header in a SOAP request message to identify protocol capabilities between an instance of [!INCLUDE[msCoName](../../../includes/msconame-md.md)] [!INCLUDE[ssNoVersion](../../../includes/ssnoversion-md.md)] [!INCLUDE[ssASnoversion](../../../includes/ssasnoversion-md.md)] and a client application.

Indicates that an exception was returned from a [Discover](../../../analysis-services/xmla/xml-elements-methods-discover.md) or [Execute](../../../analysis-services/xmla/xml-elements-methods-execute.md) method call.