Excel Online – "Unable to Set One or More Parameters" when connecting "Excel Web Access Web Part" and "Current User Filter"

I recently came across the error: I was connecting a Current User Filter to an Excel Web Access Web Part I was trying to pass the User's Login Name via the Current User Filter to a Parameter in an Excel Web Access WebPart. I first created a workbook that contained a Pivot Table and then gave one of…


OneNote Online – OneNote can't display some of your notebooks. Please try viewing them on OneDrive for Business.

I recently had several customers contact me and ask about an error they were seeing when trying to create a new OneNote Notebook. When they do this onenote.com will open, but it will throw an error: "OneNote can't display some of your notebooks.  Please try viewing them on OneDrive for Business." This is caused when OneDrive…


Excel Online – Guest Link – This workbook contains external data connections or BI features that are not supported.

Guest user have been encountering the below error when clicking on Slicers in a SharePoint Online PowerPivot workbook. "Excel Online – This workbook contains external data connections or BI features that are not supported." Here are the steps they are following: The URL ends up looking like this: https://tschauer-my.sharepoint.com/personal/admin_tschauer_onmicrosoft_com/_layouts/15/guestaccess.aspx?guestaccesstoken=DT4MuQV804mm5ydYzfQK1mmjlwGxzrWjrw8kdj%2bFEsU%3d&docid=0dc2bc40c4f484f1da7d7b30b0cc4286b If the workbook Slicers are hitting…


Excel Online – This workbook contains external data connections or BI features that are not supported.

If you are seeing the below error when uploading an Excel workbook containing a data model, you need to toggle a SharePoint Online Feature. "Excel Online – This workbook contains external data connections or BI features that are not supported." The feature you need to toggle is the Preview Features. “The preview feature is an…