Interactive browser refresh and scheduled data refresh for Power Query connections are supported on-premises with PowerPivot for SharePoint 2016. For more information, see Scheduled Data Refresh for Power Query. This may use the .1 provider, for example, when combining data from multiple sources.ĭata refresh for Power Query connections is supported by Power BI for Office 365 (SharePoint Online). In Excel 2016, the connection may be created by using the Get & Transform or Get Data feature. If the provider is .1, this indicates that the data connection was made by using Power Query. To determine whether the workbook currently has a Power Query data connection or not, view the connection string in Excel by going to Data > Connections > Properties > Definition. To do this, create a data connection by using PowerPivot and then connect to it. To work around this issue, connect to a data source that doesn't use Power Query. So both data refresh in the browser and scheduled data refresh will show an error if the workbook has a data connection that's created by using Power Query. Causeĭata refreshes for Power Query connections are not supported in SharePoint Server 2013 on-premises. When you run a scheduled data refresh on a workbook that has a Power Query connection to a data source by using PowerPivot for Microsoft SharePoint 2013, you may receive a "Call to Excel Services failed" error. This article was written by Zakir Haveliwala, Senior Support Escalation Engineer.
0 Comments
Leave a Reply. |