Error message: Query (x,x) The 'xxx' member was not found in the cube when the string, [xxx], was parsed.
Values Referenced Are No Longer Present
Note: FYI that Excel slicers can become volatile and problematic when a file is connected to an external data source. We do not advise using slicers for these reasons and do not have the ability to troubleshoot them.
Description: This error message occurs when filters or slicers in the Excel file reference a value (e.g. Calculated Account, Customer, etc.) that is no longer present in the cube. This is an Excel issue when referencing a SSAS cube.
- Try to determine which tab/cube is causing the issue. You can select 1 or more tabs and choose the MOVE/COPY option. Select "New Workbook" and check the 'make copy' checkbox.
- Remove and re-add the relevant filters or slicers.