Power BI reports failed with Expression.Error: The key didn't match any rows in the table.

Products

• Clarity PPM SaaS

Issue/Introduction

Power BI reports failed with below error

"Expression.Error: The key didn't match any rows in the table. Details: Key= Name=DWH_INV_PROJECT Signature=table Table=[Table]"

Also, when accessing Data Warehouse via Odata on desktop application tables dwh_inv_project and dwh_inv_investment are missing.

Environment

Release : 15.9.1

Component : OData

Resolution

1. Flush PowerBI cache
2. Run the full load Data Warehouse job
3. Run the Data Warehouse Access Rights job
4. Run Refresh Data Warehouse Odata Model job