Home

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

%3CLINGO-SUB%20id%3D%22lingo-sub-782555%22%20slang%3D%22en-US%22%3EExcel%20online-%20This%20workbook%20contains%20external%20data%20connections%20or%20BI%20features%20that%20are%20not%20supported%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-782555%22%20slang%3D%22en-US%22%3E%3CP%3EI%20connected%20to%20SQL%20DB%20from%20Excel%20and%20Loaded%20Model.%3C%2FP%3E%3CP%3EDesigned%20Pivot%20and%20Slicers%20in%20the%20Excel%20workbook%20and%20save%20in%20SharePoint%20Online%20Folder.%3C%2FP%3E%3CP%3EAnd%20Then%20Imported%20that%20excel%20to%20power%20BI%20Service%20from%20that%20SharePoint%20folder.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIssue%20is%3A%26nbsp%3B%3C%2FP%3E%3CP%3EWhen%20I%20open%20excel%20in%20online%20and%20try%20to%20interact%20with%20slicers%20or%20Click%20on%20refresh%20all%20connections.%20Throwing%20below%20error.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F125156iFBB37178473C4500%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%22clipboard_image_0.png%22%20title%3D%22clipboard_image_0.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20Power%20BI%20also%20Same%20issue%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F125157i2BA968B8E5BF342A%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%22clipboard_image_1.png%22%20title%3D%22clipboard_image_1.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20check%20preview%20features%20option%20enabled%20in%20SharePoint%20Admin%20site.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhat%20else%20i%20missed%20here%2C%20is%20There%20any%20settings%20do%20i%20need%20to%20enable.%3C%2FP%3E%3CP%3EI%20am%20Using%200365%20E5%20Trail.%3C%2FP%3E%3CP%3EAny%20one%20have%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-782555%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20BI%20Features%20ONLINE%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-786673%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20online-%20This%20workbook%20contains%20external%20data%20connections%20or%20BI%20features%20that%20are%20not%20suppo%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-786673%22%20slang%3D%22en-US%22%3EUnfortunately%20Excel%20Online%20does%20not%20allow%20these%20features%2C%20only%20Excel%20Desktop%3C%2FLINGO-BODY%3E
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
Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Edge insider Dev bypasses IE mode website list
HotCakeX in Enterprise on
4 Replies