Excel online- This workbook contains external data connections or BI features that are not supported

Deleted
Not applicable

I connected to SQL DB from Excel and Loaded Model.

Designed Pivot and Slicers in the Excel workbook and save in SharePoint Online Folder.

And Then Imported that excel to power BI Service from that SharePoint folder.

 

Issue is: 

When I open excel in online and try to interact with slicers or Click on refresh all connections. Throwing below error.

clipboard_image_0.png

 

In Power BI also Same issue 

 

clipboard_image_1.png

 

I check preview features option enabled in SharePoint Admin site.

 

What else i missed here, is There any settings do i need to enable.

I am Using 0365 E5 Trail.

Any one have 

 

1 Reply
Unfortunately Excel Online does not allow these features, only Excel Desktop