- Microsoft excel data analysis not showing up update#
- Microsoft excel data analysis not showing up password#
- Microsoft excel data analysis not showing up windows#
Linked data connections are most useful in scenarios in which they will be shared across many users and in which administrator control of the connection is important.Ĭhoose an embedded connection for scenarios where you need a data connection that will not be widely used. This adds configuration and administration overhead.Ĭhoose a linked data connection, by using an ODC file, for scenarios in which you must have a data connection to an enterprise-scale data source such as SQL Server or Analysis Services.
Requires server-to-server authentication between Office Online Server and SharePoint Server. Extra care must be taken to help secure these files. Linked connections are saved in clear text and may contain database passwords. Linked connections may require the help of a SharePoint administrator to share, manage and secure. Embedded data connections are more difficult to audit by SharePoint administrators. If the data connection details for a data source change, all workbooks with embedded connections to that data source will have to be republished with updated connection information.
(An example of this scenario is when the database server is moved or the database name is changed.) With that change, all workbooks that refer to the ODC file will use the updated connection information when the next refresh occurs.
Microsoft excel data analysis not showing up update#
If the data connection details for a data source change, an administrator only need update one ODC file. Workbook authors can use existing connections without having to create queries and connection strings. Linked connections can be centrally stored, managed, audited, shared and access to them can be controlled by using a SharePoint document library. Embedded connections require little administrative overhead to support. Choose the one that best suits your scenario.Ĭomparison of data connections for Excel Online Connection typeĪll connection information is stored in the workbook. Optionally, some metadata required to retrieve external dataĮach kind of connection has its advantages and drawbacks discussed here.
odc file that is also stored in the same SharePoint Server farm as the workbook. To use a linked connection, a workbook must reference an. Linked connections are stored externally to a workbook in Office Data Connection (ODC) files. Data connections for Excel Online workbooksĮxcel Online workbooks use one of two kinds of connections:Įmbedded connections are stored as part of the Excel workbook. Other data sources use a connection string usually consisting of a user name and password.
Microsoft excel data analysis not showing up windows#
To connect to the data source, Excel Online uses a specific data provider for each data source.Ĭonnecting to a SQL Server data source can be done by using either:Ĭonnecting to an Analysis Services data source is done by using Windows authentication. The following data sources are supported in Excel but not in Excel Online:Ĭonnecting to external data with Excel OnlineĮxcel Online can connect to various external data sources, including SQL Server, Analysis Services, and custom OLE DB/ODBC data providers.
Microsoft excel data analysis not showing up password#
Varies per data source, typically a user-name and password pair stored in the connection string. One of: Windows authentication (integrated security) using Kerberos Constrained Delegation using Secure Store SQL Server Authentication Windows authentication (integrated security) using Kerberos Constrained Delegation using Secure Store using the EffectiveUserName connection string property For data sources that support more than one authentication method, data connections must specify which one to use.ĭata sources and authentication methods for Excel Online Data source Which authentication method Excel Online can use to retrieve data depends on the type of the underlying data source, as outlined in the following table. In the case of a workbook, Excel Online authenticates to the data source on behalf of the user who is viewing it in order to refresh the data to which the workbook is connected. Retrieving data from a data source requires a user to be authenticated by the data source and then authorized to access the data that is contained therein. Summary Learn how Excel Online supports connections with SQL Server Analysis Services (SSAS), SQL Server databases, and OLE DB and ODBC data sources.