Excel Online – This workbook contains external data connections or BI features that are not supported.


If you are seeing the below error when uploading an Excel workbook containing a data model, you need to toggle a SharePoint Online Feature.

"Excel Online - This workbook contains external data connections or BI features that are not supported."

The feature you need to toggle is the Preview Features.

“The preview feature is an IT control feature for SharePoint Online to globally shut off access to all services where data could leave the SharePoint Online compliance boundary. This includes data that would go to Power BI. This is an IT override. When preview features are disabled Power BI is disabled as are features in Excel Online that depend on Power BI technology to deliver the feature.

If an organization wants to have strict adherence to the SharePoint Online compliance boundary they can set Preview features to disabled. If they make this choice certain features are disabled including Power BI and Excel Online features that depend on Power BI.”

Go to Admin

SharePoint

Settings

Preview Features > Enable preview features

Comments (4)

  1. Anonymous says:

    So this is not enabled by default? If not I think it should be!

  2. Tim Rodman says:

    According to this link, I should be able to refresh OData connections as long as I’m using Excel Online:
    https://support.office.com/en-in/article/Comparing-Excel-Online-Excel-Services-and-Excel-Web-App-855ee1a3-9263-425d-bccd-4070d2413aa7

    It mentions nothing about needing to enable "Preview Features". I bought "Office 365 Small Business" expecting it to work, but I get the error on the top of this page. I even turned on "SharePoint Server Enterprise Site features" but I still get the error.

  3. Tim Rodman says:

    Do I need the "Self-service Business Intelligence" feature listed here in order for this to work?
    https://products.office.com/en-us/business/compare-more-office-365-for-business-plans

    If so, then it looks like Office 365 ProPlus would be the most basic version needed.

  4. Dale Howard says:

    We have that option enabled, and yet I still see the same error dialog in Excel Online reports. How might this happen if the option is enabled?

Skip to main content