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