Login failed for user on Performance tile

Symptoms

Performance tiles anywhere in Dashboard Server show the following error instead of a graph:

access-denied-table: Cannot open database 'database' requested by the login. The login failed. Login failed for user 'Application Pool Identity'

access-denied-user: Login failed for user 'Application Pool Identity'

The application pool identity and database name may differ in your environment. For example:

Cause

The Data Warehouse connection is not correctly configured.

For example, this happens if the Dashboard Server application pool identity has been changed, but not given the OpsMgrReader role for the Data Warehouse database.

Resolution

To resolve this issue see How to check and reconfigure the Data Warehouse connection.