Hi there, I have a dashboard which worked perfectly before I refreshed the survey data (exactly the same columns, type of data etc, just more rows). When I go to refresh my pivot tables (the background ones which feed into the dashboard), I get an error message saying 'we couldn't complete the action for the Pivot Table in "dashboard" because there's already a pivot table there. Make space and try again'
When I click ok and then go back to the dashboard to use slicers etc, I get this message: 'The query did not run or the data model could not be accessed. Query (8,22) the [max of when was the last time the inspector visited?] member was not found in the cube when the string [measures].[max of when was the last time the inspector visited?], was parsed.'
Does anyone know what's happened or how to solve this?
Thanks
When I click ok and then go back to the dashboard to use slicers etc, I get this message: 'The query did not run or the data model could not be accessed. Query (8,22) the [max of when was the last time the inspector visited?] member was not found in the cube when the string [measures].[max of when was the last time the inspector visited?], was parsed.'
Does anyone know what's happened or how to solve this?
Thanks