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.
This article was written by Tom Schauer, Technical Specialist.
Symptoms
When you click slicers in a Microsoft SharePoint Online PowerPivot workbook that contains external data connections or Business Intelligence (BI) features that are not supported, you receive the following error:
This workbook contains external data connections or BI features that are not supported.
Cause
By default, a guest link URL that is provided by SharePoint doesn't include the required parameters for guests to use workbooks that contain data connections to data models or BI.
Resolution
By default, a URL that is accessed by a guest will be formatted like:
https://sharepointserver/:x:/r/_layouts/15/Doc.aspx?sourcedoc=%7B5e748b77-3447-4dce-a676-c1d12c4ef531%7D&action=default
To use the data refresh or BI function, replace "action=default" with "action=embedview&wdbipreview=true". Then the URL will be like:
https://sharepointserver/:x:/r/_layouts/15/Doc.aspx?sourcedoc=%7B5e748b77-3447-4dce-a676-c1d12c4ef531%7D&action=embedview&wdbipreview=true