I have a very basic Excel PowerPivot data model that I moved to SharePoint online. The file that I'm testing with is a basic Excel file, that contains no external data connections, and the pivot table’s data source is a table in the data model. I get the following error when I attempt to to filter the pivot table in anyway in our production environment:
“This workbook contains external data connections or BI features that are not supported”
The same file works as expected (no errors) in our test tenant. Here are some of the things I’ve tried and verified to this point (our test tenant is first-release enabled):
- Made sure my test tenant collection and production collection matched on enabled site collection features
- Same thing as above just for the individual site features
- In the test tenant, I confirmed that it worked with multiple accounts, some with the free Power BI license applied and others without
- In the production tenant, I tried with both an account that was synced through AAC and one that was created directly in the Office 365 admin interface. Same error message for both accounts.
- I’ve tried opening the file in Excel online in multiple sites in both test and production. The results are the same throughout, I can filter the pivot table in test but I can’t in production.
Is there a SharePoint setting or a feature that needs to be enabled to allow advanced analytic features such as a PowerPivot data models to function in Excel Online?