Share via

Does power query and power pivot work on Excel web version?

Anonymous
2023-10-07T02:34:19+00:00

I am getting below error while opening Excel file on web with power query and power pivot

On opening i get the yellow bar notification saying currently interacting with slicers within a group is not supported in the browser

Next when I change the slicer selection, i get the error saying this workbook contains external data connection or BI features that are not supported.

Also it doesn't support loading image that are linked to another cell through formula.

My file has the following structure.

Data table defined as named range

Used power query to process data

Added data to data model

Loaded data as pivot table from data model and added chart based on this data

Added slicer to select different parameters and change chart

Does web version of Excel support these functions?

Using office 365 on desktop.

Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments
Answer accepted by question author
  1. Ashish Mathur 101.8K Reputation points Volunteer Moderator
    2023-10-07T03:11:49+00:00

    Hi,

    Power Query and Power Pivot are not fully supported in Excel Web version. While some features may work, there are limitations and compatibility issues that may arise. The error message you are receiving indicates that the workbook contains external data connections or BI features that are not supported in the web version. Additionally, the web version does not support loading images that are linked to another cell through a formula.

    To use Power Query and Power Pivot, it is recommended to use the desktop version of Excel. If you need to access your workbook on the go, you can use the Excel mobile app, which also supports some Power Query and Power Pivot features.

    1 person found this answer helpful.
    0 comments No comments

2 additional answers

Sort by: Most helpful
  1. Ashish Mathur 101.8K Reputation points Volunteer Moderator
    2023-10-07T04:53:06+00:00

    You are welcome.

    0 comments No comments
  2. Anonymous
    2023-10-07T03:29:45+00:00

    Thanks Ashish Mathur.

    0 comments No comments