Home

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

%3CLINGO-SUB%20id%3D%22lingo-sub-782609%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-782609%22%20slang%3D%22en-US%22%3E%3CP%3EI%20connected%20to%20SQL%20DB%20from%20Excel%20and%20Loaded%20the%20Model.%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%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%2F125162i84946B5F4901D597%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%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20Power%20BI%20also%20Same%20issue.%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%2F125161iE552B2B52AC0C0E5%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%3EI%20checked%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%20Enterprise%20Trail.%20help%20me%20here%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-782609%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20for%20web%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPower%20BI%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-787936%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-787936%22%20slang%3D%22en-US%22%3ERefresh%20doesn't%20work%20in%20Excel%20online%20sorry%20Madhu%3C%2FLINGO-BODY%3E
Madhu_Tallapaneni
New Contributor

I connected to SQL DB from Excel and Loaded the Model.

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

 

clipboard_image_1.png

 

 

 

In Power BI also Same issue.

 

clipboard_image_0.png

 

I checked 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 Enterprise Trail. help me here

1 Reply
Refresh doesn't work in Excel online sorry Madhu
Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies